• RELEVANCY SCORE 3.26

    DB:3.26:Automatically Working Out And Counting The Number Of Deliveried That Were On Time Or Late In My Excel Workbook xs




    Hi There,
    Im currently designing a new data input system for work, for inputting in enquries and quotes:
    Within this workbook on the order book i have 2 columns date delivery required "d2" and date delivered "p2" and at the end of the workbook in columns "v2" and "w2" i have the columns delivery on time and delivery late...
    it it possible that when a delivery date has been entered that it automatically works out from the 2 dates if its been on time or late maybe using conditional formatting?
    But i also then want to use these two columns "on time" and "late" to summerise monthly the number of deliveries which were late and on time...

    HELP PLEEASE
    THANKS
    LEANNE

  • RELEVANCY SCORE 3.24

    DB:3.24:Down Accross Print Directions And Column Headings 9j




    I have repeating frame with down-accros print directions. My columns may or may not repeat max twice on the same page (in two columns). I would like to display column headings for the second column only if there is something displayed. For example,if the data fits in one column on the page, my page layout should look like :

    COLUMN HEADING
    data...
    data...
    data..

    If the data are displayed lin two columns, page layout should look like:

    COLUMN HEADING COLUMN HEADING
    data... data...
    data... data...
    data...

    Counting the number of records per page (reset at page ..) and then checking the number of displayed records is not the option, because of the report maintenance in the future.

    Any idea is appreciated. Thank you. Selma

    DB:3.24:Down Accross Print Directions And Column Headings 9j

    I have repeating frame with down-accros print directions. My columns may or may not repeat max twice on the same page (in two columns). I would like to display column headings for the second column only if there is something displayed. For example,if the data fits in one column on the page, my page layout should look like :

    COLUMN HEADING
    data...
    data...
    data..

    If the data are displayed lin two columns, page layout should look like:

    COLUMN HEADING COLUMN HEADING
    data... data...
    data... data...
    data...

    Counting the number of records per page (reset at page ..) and then checking the number of displayed records is not the option, because of the report maintenance in the future.

    Any idea is appreciated. Thank you. Selma

  • RELEVANCY SCORE 3.22

    DB:3.22:Counting Columns In A Data File kj




    Hi

    I'd like to find the number of columns in a data file.

    I had an idea to find the number of words ex. 'stos' in a string (the first record) but there is no function wich could count it.

    Do you have any idea what should I do?

    Message Edited by alcala on 08-06-2004 06:49 AM

  • RELEVANCY SCORE 3.21

    DB:3.21:Script For Counting Loc From Instance ps


    Hi all,

    I'm using this script to extract LOC(Lines of Code) information from server.
    find . -type f | xargs wc -l loc.csv
    Please tell me how to get it in two columns.
    one containing the LOC and other containing the file name.

    Thanks,
    Krishna Priya Bandyopadhyay

    DB:3.21:Script For Counting Loc From Instance ps

    find . -type f | while read f; do
    printf "%7d\t%s\n" "$(wc -l $f)" "$f"
    done

  • RELEVANCY SCORE 3.18

    DB:3.18:Response And Dma 98


    Hello

    I am converting a application from traditional DAQ to DAQmx. (Version 8.3)
    Programming Language: Visual Basic 6.0
    Hardware: PCI 6602

    I am using counter 0 as a gate to buffered event counting (Synchronous). Generating a continuous pulse train using counter 0 and feeding the output of the counter to counter 3 which has been setup for buffered event counting. Buffered event counting will start once it starts to get the pulse and it s been externally triggered using another pulse generated at counter 7. All these operations are inside a loop and the loop exists till the counter is armed.

    I have encountered two problems in this.

    1) Data written before it could be read by the system

    2) It s comparitively slower than traditional DAQ

    Any help would be appreciated.

    Thanks

    DB:3.18:Response And Dma 98

    Hello Rajaram,

    There is an example located on your hard drive how to do continuous buffered digital event measurement using the DAQmx C API located here : C:\Program Files\National Instruments\NI-DAQ\Examples\DAQmx ANSI C\Counter\Count Digital Events\Cnt-Buf-Cont-ExtClk\ .

    Take a look at this to gain an idea on how to approach your programming by looking at which functions are called and with what parameters. You will need to then port these ideas over to you VB code.

    Post back if you need further help.

    Good Luck!

    Tom | NIUK

  • RELEVANCY SCORE 3.07

    DB:3.07:Primary Key Generation On Import Is Problematic At Times m8


    Hi HTML DB team,

    please consider the following data I want to import

    ID VALUE
    1 One
    2 Two
    3 Three

    I use the import feature:
    - Import to: new table
    - Import from: copy and paste
    - Paste the data
    - Check the columns
    - Primary key from: Use an existing column (since the ID has been my primary key in the excel sheet)
    - Primary Key Population: Generated from a new sequence (since I want for all ADDITIONAL rows to have a new key generated, but not for the ones I want to import)

    The generated trigger is:
    for c1 in (
    select "PJM_TODOS_SEQ".nextval next_val
    from dual
    ) loop
    :new."ID" := c1.next_val;
    end loop;

    - Using this, even my existing IDs will be overwritten on import.
    - If the import fails and and I reimport into this now existing table, the sequence will continue counting another set of rows

    Is there a specific reason why have implemented it this way? The IDs will always be overwritten on import for primary keys based on existing columns.

    An easy way to circumvent this would be the following:
    IF :NEW."ID" IS NULL THEN
    SELECT "PJM_TODOS_SEQ".NEXTVAL
    INTO :NEW."ID"
    FROM DUAL;
    END IF;

    I usually use this logic since it gives me more control over when I want to have a key generated and when not.

    Regards,
    ~Dietmar.

    DB:3.07:Primary Key Generation On Import Is Problematic At Times m8

    Hi HTML DB team,

    please consider the following data I want to import

    ID VALUE
    1 One
    2 Two
    3 Three

    I use the import feature:
    - Import to: new table
    - Import from: copy and paste
    - Paste the data
    - Check the columns
    - Primary key from: Use an existing column (since the ID has been my primary key in the excel sheet)
    - Primary Key Population: Generated from a new sequence (since I want for all ADDITIONAL rows to have a new key generated, but not for the ones I want to import)

    The generated trigger is:
    for c1 in (
    select "PJM_TODOS_SEQ".nextval next_val
    from dual
    ) loop
    :new."ID" := c1.next_val;
    end loop;

    - Using this, even my existing IDs will be overwritten on import.
    - If the import fails and and I reimport into this now existing table, the sequence will continue counting another set of rows

    Is there a specific reason why have implemented it this way? The IDs will always be overwritten on import for primary keys based on existing columns.

    An easy way to circumvent this would be the following:
    IF :NEW."ID" IS NULL THEN
    SELECT "PJM_TODOS_SEQ".NEXTVAL
    INTO :NEW."ID"
    FROM DUAL;
    END IF;

    I usually use this logic since it gives me more control over when I want to have a key generated and when not.

    Regards,
    ~Dietmar.

  • RELEVANCY SCORE 3.06

    DB:3.06:Counting Columns/Occurences In A Select Statement. 3c


    Hi folks,
    I would like to know the number of columns being selected in a SELECT statement.
    For example, let the SELECT statement be like this.

    SELECT COL1,COL2,COL3,COL4(,..so on ) FROM TABLE_NAME;

    I'd thought of a concept of counting commas between SELECT and FROM clauses but got stuck up in counting the occurences of commas. Is there any function to count the occurences of any string in an expression? If so, please tell me.

    Your favour will be deeply appreciated.

    Cheers, PCZ.

    DB:3.06:Counting Columns/Occurences In A Select Statement. 3c

    Hey, try this:
    DECLARE
    cnt number := 0;
    cur number := dbms_sql.open_cursor;
    begin
    dbms_sql.parse(cur,
    'select 1,2,3,4,5,6,7,8,''9'', sysdate as "10" from dual',
    dbms_sql.native);
    for i in 1 .. 1000 loop
    begin
    dbms_sql.define_column(cur, i, i);
    cnt := cnt + 1;
    exception
    when others then
    exit;
    end;
    end loop;
    dbms_sql.close_cursor(cur);
    dbms_output.put_line(cnt);
    end;
    /
    10

    PL/SQL procedure successfully completed.

    SQLAmiel Davis

  • RELEVANCY SCORE 3.06

    DB:3.06:Columns In Data Grid 1d


    hi,
    i have this setting for data grid -- sdk:DataGrid AutoGenerateColumns=False Name=dataGrid1 Grid.Column=2 /
    and it load two columns instead of --

    please help, thanks

    DB:3.06:Columns In Data Grid 1d

    If you have a single column grid that you want to fill all available space in your DataGrid, then just specify
    ColumnWidth=* on your DataGrid. This should do it and you won't have to mess with auto sized grid panels.
    Just put things back to the way you had them and add that stared ColumnWidth.

    I hope this helps.
    Brice

  • RELEVANCY SCORE 3.04

    DB:3.04:How Do I Add Columns Of Data To An Existing Spreadsheet? 8s


    My program records data to a spreasheet. Right now it records in columns 1-4. I would like to be able to have a control to set the test number, which will add a new set of columns to my spreadsheet. Test one will record the data in columns 1-4, test two will record in columns 6-9, test three in 11-14... How can I do this?

    DB:3.04:How Do I Add Columns Of Data To An Existing Spreadsheet? 8s

    If you are using the example Write Table to XL, then this is not difficult because in that example you set the actual column and row to place the data.However if you are creating a tab delimited text file then this is actually difficult and slow. To take the following table 1 23 4into a text file the actual string written is 1\t2\n3\t4\n where \t are tabs and \n are new lines.So to add a new column with the values 5 and 6 you would need to actually read the entire string in then insert the values in the middle of the string. Ending up with the sting 1\t2\t5\n3\t4\t6\n Finally you would need to write the whole string back to the file, replacing all the text. EvanNational Instruments

  • RELEVANCY SCORE 3.03

    DB:3.03:Comparing Two Columns Of Data For Discrepancies 7s


    I have two columns of idential numbers pulled from 2 different spreadsheets. I'm trying to find out if there is a way to have Excel compare the two columns for possible discrepancy. For example Col. A = 900, Col. B should also = 900. Thank you.

    DB:3.03:Comparing Two Columns Of Data For Discrepancies 7s

    Sureanytime! Thanks for the feedback!!!

    Glad to help,
    ~jaeson

  • RELEVANCY SCORE 2.99

    DB:2.99:Count Total # Of Lines Including Nulls fx



    Hey so I have an excel file that has 802 lines of data with two columns, one being product and the other being model. In this data, some of the products or model repeats, so if I count distinct product and model there is 757 and 340 respectively. Anway, I try counting the Model with using the technique set analysis:

    Count(ALL {Product = {'*'} Model)
    But I get 757 as the total #, which is not what I want, it should add up to be 802. I did it another way but creating a table and having an expression to set every line to 1 and do the sum of that and I get 802. My question is, is there a function in qlikview that allows me to count every single line items, even the ones that are null?

  • RELEVANCY SCORE 2.98

    DB:2.98:Counting Rows In C# 73



    Hello, i got a DataFile in Excel with 2 Columns. A - B
    Ill like to read all data in Column B (About 4000 entries) but ill like C# to tell me, how many Rows are exactly in that Column, i know how to get the total count of rows, but that is for a complete files (Columns A to XXX) with the code
    RowCount = WorkSheet.Rows.Count;
    know, how do i count the Rows used but only in one Column.
    Thanks In Advance.

    DB:2.98:Counting Rows In C# 73

    Fixed It... :)
    This is an Example Code for reading how many Writed Rows are in the Second Column of an Excel File

    int Model = 0;
    Excel.Range Range = (Excel.Range)WorkSheet.Columns[2];
    Model = Range.CurrentRegion.Rows.Count;

  • RELEVANCY SCORE 2.98

    DB:2.98:Counting Data In Excel 3f


    I have two columns, one that contains the following:

    EXAMPLES OF DATA IN COLUMN C:
    BRB CCW
    BRB RRB
    BRB AWB
    BRB CWB
    (there is more data in COLUMN C, but in my count I want to filter for BRB)

    EXAMPLES OF DATA IN COLUMN F:
    00:00:47
    00:50:32
    01:32:00
    02:00:00
    03:45:32
    and so on (this is time format, from 0 to 24 hours)

    I want to count the data in COLUMN F (broken down as follows), where COLUMN C contains "BRB":

    less than 01:00:00
    01:00:00 to 02:00:00
    02:00:00 to 03:00:00
    03:00:00 to 04:00:00
    04:00:00 to 05:00:00
    05:00:00 to 06:00:00
    06:00:00 to 07:00:00
    07:00:00 to 24:00:00
    greater than 24:00:00

    I hope this makes sense. Thanks for the help.

    DB:2.98:Counting Data In Excel 3f

    Assuming every item you want to count starts with BRB you could use the following array formula tocount the less than 1 hour items:
    =COUNT(IF((FIND("BRB",C2:C8,1)=1)*(F2:F8=1/24),F2:F8))
    You need to press Ctrl+Shift+Enter to enter this as an array formula.
    This array formula will count items between 1 hour and less than 2 hours:
    =COUNT(IF((FIND("BRB",C2:C8,1)=1)*(F2:F81/24)*(F2:F8=2/24),F2:F8))
    If the BRB can occur anywhere in each item in column C then you could change the FIND part to

    FIND("BRB",C2:C8,1)=1
    Hopefully you can work out how to change the formula to calculate for the other time periods.

  • RELEVANCY SCORE 2.97

    DB:2.97:Compare Data Between Two Tables jk


    Hey Experts
    I am having two tables both are having same structure.
    Both r having 210 columns

    I want to compare data between these two tables.

    I used follwoing query

    select * from t1
    MINUS
    select * from t2but even if thr is diff in 1columns .. i need to search 210 columns which is the exact columns and data

    how can i find the exact columns out of these 210 columns ?

    DB:2.97:Compare Data Between Two Tables jk

    You Can make use of Data Dictionary tables like User_columns or all_columns.

  • RELEVANCY SCORE 2.97

    DB:2.97:Up-And-Down Query 89


    Hi, Kumar,

    It would help a lot if you could post a query that actually works with the data you posted.
    The query you posted refers to columns like "sup_name" and "emp_name" that don't appear in the sample data.

    It would also help if you could format your code to show wherre one sub-query ends and the next one begins, and what the various clauses in each sub-query are. Type before and after code fragments to preserve spacing.

    If the compression due to vacant positions is significant, shouldn't your sample data have an example of such a vancancy?

    I think you need to do an +Up-and-Down+ hierarchical query.
    The problem seems to be that you're counting levels from the bottom-up. When two paths converge at a node (like 'P4', which is at level 4 in the path beginning at 'P1', but at level 2 in the path beginning at 'P31') you are correctly getting the largest value.
    What you have to do next is a top-down CONNECT BY query, starting at the leaves of the bottom-up query ('P4' is the only such node in your sample data).
    In other words, you should first do a bottom-up query, like you're already doing, to determine that 'P4' is a leaf, at level rn. Then do a top-down query, starting with 'P4', and compute rn - (LEVEL - 1).

    DB:2.97:Up-And-Down Query 89

    Hi Davide - You are right. But, this is what I see as the positions under P5:

    P5 --gt; 1
    |
    P4 --gt; 2
    / \
    / \
    P3 P31 --gt; 3
    /
    /
    P2 --gt; 4
    /
    /
    P1 --gt; 5That is how I feel that both P31 and P3 are at the same levels and they should both be seen as the levels under P5 and P4. Thanks.

    Kumar

    Edited by: user572405 on Jan 11, 2009 9:07 PM

    Edited by: user572405 on Jan 13, 2009 5:14 PM

  • RELEVANCY SCORE 2.96

    DB:2.96:Using Multiple Arrays In Countif 91


    Trying to find correct formula and syntac for counting rows that contain two columns of text. Example. One column has Low, Med, and High, and the other column has Red, Blue Green. I want a count of the Med with only Blue and Green.
    Thanks!

    DB:2.96:Using Multiple Arrays In Countif 91

    Here is one formula that would work, assumes that A2:A13 hold the Low, Med, High entries and B2:B13 hold the color entries:
    =SUMPRODUCT(--(A2:A13="Med"),--(B2:B13="Green")) + SUMPRODUCT(--(A2:A13="Med"),--(B2:B13="Blue"))
    Note that the use of "Med", "Green" and "Blue" could be replaced with a reference to a cell that contains those particular words also.

  • RELEVANCY SCORE 2.95

    DB:2.95:Beyond: Two Souls Parody Song Of Counting Stars By Jonnycakes c8



    http://www.youtube.com/watch?v=WYAA5fjtTzE

  • RELEVANCY SCORE 2.93

    DB:2.93:Is There A Method For Counting Words? 3d


    Hi!

    Is there a method for counting words?
    How do I read specific data ( row, column ) out of an array?

    Thx
    Lebite

    DB:2.93:Is There A Method For Counting Words? 3d

    Thanks Ceranith!

    This online support forum is great. I have to program
    an application for my school, and I have really problems
    programming it in Java!
    Here some Duke Doller for you :-)

  • RELEVANCY SCORE 2.93

    DB:2.93:Help With Setting Up A Formula pm


    I am trying to do the following:
    I want to count how many High - Critical rows I have in my data that has the variables in the columns (such as How many High - Critical (row) lines do I have that has No Impact (column). My named range is called "Data". I tried the countif statement it was
    only counting the High - Critical and I need it to count the number of High - Critical lines that have no impact as a attribute (separate column).

    Data name is "Data
    High - Critical starts at cell b6
    No Impact is found in cell e4.

    Data is set up as shown in rows and columns below:
    Rows
    High - Critical
    High
    Medium
    Low

    Columns
    No impact
    Impact
    Questionaire
    Complete

    DB:2.93:Help With Setting Up A Formula pm

    Hi, use one of the following sites and then post the URL so I can access the sheet

    MediaFire: http://www.mediafire.com

    FileFactory: http://www.filefactory.com

    FileSavr: http://www.filesavr.com

    FileDropper: http://www.filedropper.com

    RapidShare: http://www.rapidshare.com

    Box: http://www.box.net/files

  • RELEVANCY SCORE 2.92

    DB:2.92:Requirement In Web Analysis dx


    Hi Experts,
    We are designing a new Chart report in Web analysis, in "Rows" their are three members and the "Columns" contain two members.
    Our Client requirement is that Two specific Dimension members Of "Rows" should show Data specific to One dimension member of "Columns" and One specific Dimension members Of "Rows" should show Data specific to One dimension member of "Columns".
    Is it possible?
    Can Anyone please help on this.

    Regards,
    ACE

    DB:2.92:Requirement In Web Analysis dx

    Hi Experts,
    We are designing a new Chart report in Web analysis, in "Rows" their are three members and the "Columns" contain two members.
    Our Client requirement is that Two specific Dimension members Of "Rows" should show Data specific to One dimension member of "Columns" and One specific Dimension members Of "Rows" should show Data specific to One dimension member of "Columns".
    Is it possible?
    Can Anyone please help on this.

    Regards,
    ACE

  • RELEVANCY SCORE 2.92

    DB:2.92:How Do I Get The Daq Assistant Counter To Wait For 1st Trigger Pulse To Begin Counting? sp



    Hi,

    I am attempting to build a counting VI to count pulses in an interval controlled by an external trigger. I have the counter counting but my 1st two data points are random. How do I get the counter daq to wait until it receives a trigger pulse before it begins adding counts to the buffer? Right now I am feeding the DAQ square wave pulses at 100Hz and triggering the counter to output everytime it receives a trigger (10Hz square wave).

    My outputed data looks like this:

    3147

    -120

    30

    30

    30

    30

    I should be seing all 30s.

    Below is a pic of my setup. Thanks for your help!

    DB:2.92:How Do I Get The Daq Assistant Counter To Wait For 1st Trigger Pulse To Begin Counting? sp


    Hi Matt99eo,

    Have you configured your device for triggering? Although you have not mentioned your device specifically, the M series user manual provides a great explanation of digital triggering. Using the DAQ Assistant, this can be configured from the triggering tab. Hopefully this helps!




    Regards,h_bakerNational Instruments Applications EngineerDigital Multimeter Resources

  • RELEVANCY SCORE 2.90

    DB:2.90:Data Grid x9


    is there data grid(data list) property in java? if possible could you give a little example in a mdb database of two records and two columns(name,surname)?

    thanks

    DB:2.90:Data Grid x9

    [url http://java.sun.com/docs/books/tutorial/uiswing/components/table.html]JTable

  • RELEVANCY SCORE 2.90

    DB:2.90:Mapping Load c8



    Does mapping load requires two columns of data? Is it necessary?

    DB:2.90:Mapping Load c8


    hi

    the concept of mapping table is that,

    the mapped table(table1) have atleast two column(field name), 1st column must be primary key and on the basis of it we mapped the 2nd column from table2.

    primary key must be common in both table.

    example--

    mapping load

    productid,

    productname from table1;

    load orderid,

    item,

    quantity,

    productid

    Applymap('table1',productid) as productname

    from table2;

    hope this helps you.

  • RELEVANCY SCORE 2.90

    DB:2.90:Regarding Data In Second Page cj



    hi all,

    I am doing one smartform. It is having Two Pages. I Created one Final Internal Table that is having 50 columns. First 25 columns are in First Page and Next 25 Columns are in Second Page.

    I am Using COMMAND Option for Triggering of Second Page in Footer option of Table( Main Window).

    Data is Coming for First 25 columns (1 st Page ) , but data is not coming for next 25 columns ( Second Page).

    How Can I Get Data in Second Page.

    Please Suggest.

    Regards

    Reddy

    DB:2.90:Regarding Data In Second Page cj


    Ramireddy,

    Place the command in the 25th column .

    i actually did not get ur question at all.

    Are you trying to put the data seperately into 2 different pages

    i mean then where would you get the continuation of the data.

    Footer gets triggered only when your main internal table has finished priocessing all the line items

    hence it did not work.

    Regards,

    Ravi Kiran

    Edited by: Ravi Kiran Bherthepudi on Dec 3, 2008 12:57 PM

  • RELEVANCY SCORE 2.90

    DB:2.90:Count First Two Columns p7



    Hello,

    I have a count requirement that i havent been able to solve by searching sdn. Maybe someone can help.

    I have a query built on a multiprovider that points to two basic cubes. The basic cubes do not contain a count key figure. The first two columns of my query are characteristics. My requirement is to count the occurences of the combination of the first two column (characteristics). I am looking for a way to do this in the query so i do not have to reload the cubes as they have large volumes of data. All the suggestions i have been able to find on sdn seem to be only for counting a single characteristic. Is there a way to count the combination of two?

    Regards,

    TMS

    DB:2.90:Count First Two Columns p7


    Hi Create a count using the formula or calculated ket figure for the count unique id like client id for your infocube.

    so you will have a count for each row now. place this count object in your column.

    now select the two char or the group whatever you want a count in your row.

    select query properties and select the display tab and make sure the option - hide repeated key values is selected (normally by default it is selected). Then select each of the char in rows and in free char and set the option under display tab result rows - always suppress.

    Execute the query now. you will get the list of char and their count. sort the count by descending to get the most duplicate entries by their highest number on top in the count coulmn.

    you can also ignore the rows which donot have a duplicate i.e count more than 1 by creating a new condintion on the count key figure 1 and restricting the condition by only the group of char you have given in the column. so that you can also do a drill down by free char in your query and it will only show the duplicates group.

    Hope it helps.

    regards,

    Siva

  • RELEVANCY SCORE 2.89

    DB:2.89:Count Points When Data Comes From Sqldatasource zm


    Hi,
    I have a stacked column chart with three series and X number of columns. I want to retrieve the number of columns for a computation. I thought counting the number of columns could be done by counting the number of points in one of the series. This seems
    to work if I add points manually but not if the data comes from a SQLDataSource.
    Does anyone have any ideas how I can achieve either counting the points on a chart supplied by a SQLDataSource or ultimately how to count the number of columns in a stacked column chart.
    Thanks
    Andy

    DB:2.89:Count Points When Data Comes From Sqldatasource zm

    Hi,
    I have a stacked column chart with three series and X number of columns. I want to retrieve the number of columns for a computation. I thought counting the number of columns could be done by counting the number of points in one of the series. This seems
    to work if I add points manually but not if the data comes from a SQLDataSource.
    Does anyone have any ideas how I can achieve either counting the points on a chart supplied by a SQLDataSource or ultimately how to count the number of columns in a stacked column chart.
    Thanks
    Andy

  • RELEVANCY SCORE 2.89

    DB:2.89:Using Countif And Removing Duplicates In Two Different Columns. zm


    I have a person's name in column A and their title in column B. I'm trying to count the number of titles, but they are counting the title in the person's name appears more than one time. Can you please help?

  • RELEVANCY SCORE 2.88

    DB:2.88:Matchfilter Data kp


    I have two sets of data/figures, one set having 17 columns by 180 rows and the other set of 7 columns by 190 rows.

    Both of these have an 'order number' as one oftheir columns, how do I match/filter these together into one area of figures/data?
    Any help is appreciated
    Regards
    Peter

    DB:2.88:Matchfilter Data kp


    'A2 is the order number' - why A2?

    The formula is for line 2 and A2is the cell reference where the order number is stored.
    This relies on the order number being in the left hand column of the lookup table, it's a limitation of lookup. This can be worked around but makes it more complicated.

  • RELEVANCY SCORE 2.88

    DB:2.88:Add New Datagrid Columns Dynamically z8


    How to create the datatable columns dynamically as per the user needs and bind to the data grid.
    Initially i have two columns in datagrid. User must be able to add any number of columns dynamically.

    DB:2.88:Add New Datagrid Columns Dynamically z8

    Hi FishaMeena,
    You can dynamically add new DataGridColumn objects to
    DataGrid.Columns property to add new columns.
    The following sample is quoted from the above linked documentation.

    //Create a new column to add to the DataGrid
    DataGridTextColumn textcol = new DataGridTextColumn();
    //Create a Binding object to define the path to the DataGrid.ItemsSource property
    //The column inherits its DataContext from the DataGrid, so you dont set the source
    Binding b = new Binding(LastName);
    //Set the properties on the new column
    textcol.Binding = b;
    textcol.Header = Last Name;
    //Add the column to the DataGrid
    DG2.Columns.Add(textcol);

  • RELEVANCY SCORE 2.87

    DB:2.87:Need Query To Compare The Columns Of 2 Diff Tables Of 2 Different Schemas. 73


    There are two different tables(sample1, sample2) in different schemas(s_schema1, s_schema2).

    I want the query to compare the columns of two different tables of two different schemas and provide whether the data as well as the count of data in
    the column are same .

    if not provide the data which is not similar in the columns of two different table.

    NOTE:

    I need queries for both the cases.
    (i) The datatypes in columns of two different tables are same.
    (ii) The datatypes in columns of two different tables are diffrent.

    DB:2.87:Need Query To Compare The Columns Of 2 Diff Tables Of 2 Different Schemas. 73

    Welcome to the forum!

    Whenever you post provide your 4 digit Oracle version.

    I need queries for both the cases.

    Great - write the queries!

    The forum is not a coding service where you ask people to write code for you for free.

    YOU need to write the code. Then if you have a problem with the code you have written post the code you have written (using \ tags) and explain the problem you are having.

    Read the FAQ about how to ask a question on the forums.

  • RELEVANCY SCORE 2.87

    DB:2.87:Proc Sql -Increment Counting pj



    Hello all,

    Is there is an easy way within PROC SQL to count the rows? Normally I can just use _N_ in the data step process but would like to handle the query in one step instead of two.

    Thank you.

    Lawrence

    DB:2.87:Proc Sql -Increment Counting pj


    Relational database fields are indeed unordered. But, SAS data sets are ordered, and it is often easier to use a proc SQL for something than a proc sort-data step-proc means/whatever. Also, if you are really using a relational database, you can use passthough SQL to access whatever custom row ordering function that database offers.

    With large complex datasets, there are often transactions that don't fit the "documented" rules. It is useful to put row numbers into a table so that you can easier find the duplicates values (monotonic unfortunately doesn't guarantee missing values). If you are already sub-selecting the primary table, then you can cut out an additional data step to just number them.

  • RELEVANCY SCORE 2.87

    DB:2.87:Create Several Outline (Groups) Of Columns In Excel On A Table Populated By Data From Sql Server kx


    I have a worksheet in Excel with a table populated with data fetched with a query from SQL server. These data have always 6 columns fixed plus, depending on the parameter passed to the query, (n*14) columns, where n is an integer from 0 to 10.
    Leaving the 6 fixed columns ungrouped, I made 10 groupings counting 14 columns each. However I found two drawbacks:
    1) Adjacent groupings get merged, so instead of having 10 distinct grouping of 14 columns each, I end up with 1 grouping of 140 columns. The only way is to place an empty cell after the last column of each grouping but it is not the behavior I would like
    to have.

    2) If I use the empty cell workaround for the groupings, when I refresh the table and the number of columns returned is shorter/longer, all the expand/collapse button are shifted outside the table and of course they work on empty cells.
    Anybody knows a way to perform grouping without incurring in such issues? As a bonus, is it possible to give a label name to a grouping? Thanks

    DB:2.87:Create Several Outline (Groups) Of Columns In Excel On A Table Populated By Data From Sql Server kx

    I'm not very clear.Maybe upload somescreenshots will be clear.
    And if you donot program for your question, I think you might ask from Technet:
    http://social.technet.microsoft.com/Forums/en-US/home?forum=excelfilter=alltypessort=lastpostdesc

  • RELEVANCY SCORE 2.87

    DB:2.87:Combining Two Columns Of Data Into One Column With All Possible Variations Of Combination mc


    What I would like to accomplish is combining data in COLUMN A with data in COLUMN B to create all possible iterations of the combination in COLUMN C. I guess you could call it multiplying the columns.

    COLUMN A

    one
    two
    three

    COLUMN B

    steak
    burrito
    cheese

    COLUMN C

    steak one
    steak two
    steak three
    burrito one
    burrito two
    burrito three
    cheese one
    cheese two
    cheese three

    Can I use a formula to do this?

    DB:2.87:Combining Two Columns Of Data Into One Column With All Possible Variations Of Combination mc

    Hi,

    You may refer to my solution at this link -
    http://www.ashishmathur.com/create-all-possible-combinations-from-different-ranges-without-using-vba/

    Hope this helps.

  • RELEVANCY SCORE 2.86

    DB:2.86:Counting Data In Date Range da


    Hello,If I have the following columns (which I have data that goes back for two years), how can I create a formula that will give me the number of times a specific contact type was identified but in a specified date range.So I would like to have two input cells that I can just type the beginning and ending date and the formula would just take those dates as the range and spit out a number....please help!!! I feel like I have been beating my head about this for about 6 hours now. Thanks for your time.DateContact TypeJan 1, 2012No ContactJan 2, 2012EmailJan 3, 2012No ContactJan 4, 2012EmailJan 5, 2012EmailJan 6, 2012PhoneJan 7, 2012No ContactJan 8, 2012No ContactJan 9, 2012No Contact

    DB:2.86:Counting Data In Date Range da

    There are many ways to get into trouble, especially as you are starting out. For instance, if you have a date that is really a text string and not recognized as a Date variable, it will fail in a comparison with an actual Date variable. Whenever you have trouble, strip down the function and build it up one parameter at a time. In this case, you could begin by trying to count the contact types, regardless of date.In my example, you could begin with: =COUNTIFS(Data :: B, C)That will check your contact match elements. Then you could test with:=COUNTIFS(Data :: $A, "="A)That will count the number of entries greater than or equal to the start date, regardless of end date or contact type. If this works, you have the date comparison thing down pat. At this point, just put it all together.Good luck,Jerry

  • RELEVANCY SCORE 2.85

    DB:2.85:Ora 01461 Error When Loading Data From Excel To Table 3a


    i am trying to load data from excel to table through apex.
    data has 6 columns , 4 columns are of number type two columns are of varchar2 type
    code varchar2(15)
    description varchar2(150)

    data is definately less length than column width , but still error occurs when try to load data from excel.

    i increased size from 100 to 150, but not working.

    DB:2.85:Ora 01461 Error When Loading Data From Excel To Table 3a

    Hi,

    Whilst I do have SQLDeveloper, I can not use the export functionality (not sure why, but I can not see a complete list of tables to select from).

    You would need to do something similar to my previous post and output data surrounded by ~ characters.

    If this is not possible (and I do not know the options that are available), then you could generate the output using a query like:

    SELECT '~' || EMPNO || '~,~' || ENAME || '~'
    FROM EMPAnd then copy/paste the results into a text document

    Andy

  • RELEVANCY SCORE 2.85

    DB:2.85:Counting The Number Of Occurrences Of A Name In A Column Tied To A Date Without Knowing The Actual Name m8



    I have two columns of data: date name. I want to be able to go to the date column, record the date in a cell, go to name column, record the first name in a second cell, and then record the number of time that name occurs
    for that date and record the number in a third cell. Then go to the next date and so on until all dates with applicable names occurrences are recorded. The date is in MM/DD/YYYY format. I tried countifs but it is alluding me. Thank you.

    DB:2.85:Counting The Number Of Occurrences Of A Name In A Column Tied To A Date Without Knowing The Actual Name m8

    Tushar, Because of your suggestion I have discovered that some dates also have times attached to the date. I can not see that time until I click on an individual cell even though the column width is plenty wide. Some cells have the date with
    time and some only the date. I need to remove the time portion so I only have bare date. How the heck do you truncate a cell to only show a date? Some cells have just 5/3/2010 let's say and some cells will have 5/3/2010 11:30:00 AM or 5/3/2010 11:00:00
    AM. This is showing up as 3 different dates in the pivot table. So it is my data and not your method. Any ideas.

    One option is to 'group' the data. Right-click on the 1st date in the PivotTable and select Group... Experiment with the choices in there.
    Another option is to modify the data source. Suppose your current data are in B:C with row 1 as the header row. Then, create D as a 'Date Only' column. In D2 enter the formula =INT(B2). Copy D2 as far down D as you have data in B:C. Now, base your PT
    on C:D.

    Tushar Mehta (Technology and Operations Consulting)
    www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
    Microsoft MVP Excel 2000-Present

  • RELEVANCY SCORE 2.84

    DB:2.84:Summing Data Based On Two Columns 8s


    i have a spreadsheet with multiple columns of data. I want to get subtotals based on two columns. Is this possible? so if column G and column H contain the exact same information - i want to subtotal column I

    DB:2.84:Summing Data Based On Two Columns 8s

    @ediardp,
    ... (column A includes company information so the data is sorted by company first) ...
    The OP did make a somewhat obscured reference to company information in column A in his most recent reply. That was what I derived my proposed solution from.

    "Have you tried turning it off and then on again?" - Roy from 'The IT Crowd' (Emmy award-winning British comedy)

  • RELEVANCY SCORE 2.84

    DB:2.84:Column Widths Changes If Data Is Updated pp



    Hi ,

    I am using Flex 3 Datagrid. I have one case senario where i have to hide some of the columns in the grid based on certain conditions. I also have two radiobuttons which changes data in the datagrid.

    The problem is , when the columns are hidden then initially columns looks good but after i change radio buttons(or data gets changed) the columns widths changes.

    Can anybody help please???

    Thanks

  • RELEVANCY SCORE 2.84

    DB:2.84:Re: Double Counting Of Structural Columns In Linked File dj



    Hello,

    I have Documentation file in which are linked Structural model. When I create schedule of Structural Columns, I get strange results: Revit calculates correct number of columns, but it also makes another line in schedule with blank cells except Count column, in which are the same number of Columns. Maybe anyone know the answer why Revit is making this extra line?

    PS.: In model file this schedule looks good.

    DB:2.84:Re: Double Counting Of Structural Columns In Linked File dj


    Hi,

    Please find the attached image file and see whether you have activated that option. Can be solved your problem with this.

    Thanks regards,

    Subhradeep Sen

    Kolkata

    India










    Attachments:






    Schedule with Linked Files.png ‏43 KB

  • RELEVANCY SCORE 2.83

    DB:2.83:Two Counters Counting Respectively j1



    Hello,

    I need two counters that counting respectively. First counter counting from 0 to 15 and the second counter counting from 0 to 7.

    when the first counter reached to 15, the second counter begins to counting while the first counter counting too.

    at first:

    first_counter : 0,1,...,15.

    second_counter : UUU.

    after the first counter = 15 :

    first_counter : 0,1,...,15.

    second_counter : 0,1,...,7.

    the result of my code: Only the first counter counting.

    I have attached my code.

    Please guide me.

    Thanks







    Solved!
    Go to Solution.

    DB:2.83:Two Counters Counting Respectively j1

    after the 4 leds of the first counter, turn on like that counting from 0 to 15, all the 3 leds for the second counter turn on together, and they do not counting.

    "All LEDs on" is indistinguishable from "counting so fast that it looks like all LEDs are on". An oscilloscope can distinguish between the two conditions. What is the clock frequency?

    -- Bob Elkind




    SIGNATURE:README for newbies is here: http://forums.xilinx.com/t5/New-Users-Forum/README-first-Help-for-new-users/td-p/219369Summary:1. Read the manual or user guide. Have you read the manual? Can you find the manual?2. Search the forums (and search the web) for similar topics.3. Do not post the same question on multiple forums.4. Do not post a new topic or question on someone else's thread, start a new thread!5. Students: Copying code is not the same as learning to design.6 "It does not work" is not a question which can be answered. Provide useful details (with webpage, datasheet links, please).7. You are not charged extra fees for comments in your code.8. I am not paid for forum posts. If I write a good post, then I have been good for nothing.

  • RELEVANCY SCORE 2.82

    DB:2.82:Columns In Exported Excel-Sheet? 1z


    Hi,I'm exporting three data-channels to an excel-sheet after measure, when I open this file, there is always one more column (counting 1,2,3...).How can I export an excel-file without this column Does somebody know an helping answer?Nico

    DB:2.82:Columns In Exported Excel-Sheet? 1z

    Hello Tastenmann,as far as I know the Export Wizard automatically creates that reverence channel and cannot be told not to do it.Beside the incrementing numbers it contains the titles of the channel properties that were exported together with the data.Keep in mind that you may also export DIAdem to Excel via the Windows Clipboard, that means just by using the copypaste functions. In that case no extra channels will be generated.I. SchumacherApplication EngineeringNational Instruments

  • RELEVANCY SCORE 2.81

    DB:2.81:Datagridview Column Data Not Showing 38


    I am creating a DataGridView with AutoGenerateColumns set to false so that I can add my own columns. I am binding the datagridview to a datatable, and the first two columns of the DataGridView should just be ordinary DataGridViewTextBoxColumns to display text, the rest of the columns are DataGridViewCheckBoxColumns. My problem is that my first two columns aren't showing any data, but the rest of the columns, the checkbox columns, are working perfectly. I know that the datatable has data in the first two columns, but I can't figure out why it's not displaying. The column names for the columns are displaying though. Here is how I create them:

    Code Snippet

    DB:2.81:Datagridview Column Data Not Showing 38

    Hi, ekb0211,
     
    I tried your codes, and they perform well in my computer.
    Please check whether the names of Text Columns are exactly the same names of the columns in your datatable.
     
    Besides, please add your columns before setting the datasource,
    because it can improve your application's perfomance.
     
    Hopes this helps,
    Regards

  • RELEVANCY SCORE 2.81

    DB:2.81:Counting Up Occurances Of Specific Data Across A Range Of Columns 77


    Microsoft Excel 2007: I have set up a spreadsheet as a calendar for my team, with dates across the top as my column headings (one column for each day covering a three month period, so approx 90 columns), and names of my team members going down as rows.
    I enter different types of absences into the sheet for holidays, sickness, that kind of thing. I want to use the calendar to determine two different pieces of information for each absence type: 1) the total number of absences booked in the period, and 2) the
    number of absences taken up to the current date only (ie not including days booked in the coming weeks).
    For the first I am using COUNTIF() to determine the total number of absence types in the whole sheet. For example, to determine the total number of holiday days booked I use:
    =COUNTIF(WholeCalendar,"H") where WholeCalendar is a named range covering the whole calendar.
    For the second, as each day passes I need to total up the number of cells in all rows containing "H" but only up to the "todays date" column. Obviously each day the "todays date" column moves a position to the right! I figure I need a dynamically adjusting
    ToDateCalendar named range which includes all the columns upto the "todays date" column, but how do I do this please? Is there a better way of doing this? I have tried using COUNTIFS to count up but this only seems to work across a single column or row of
    data, rather than multiple rows or columns.

  • RELEVANCY SCORE 2.80

    DB:2.80:How To Start A Line Graph At The Top Right Corner Of A Column In A Pareto Chart? 9c


    I need to create a graph with two data series. The first series consists of columns that depend of the primary axis and the second series is a line graph that uses a secondary axis. I need this to create a pareto chart and I need the line series to start
    form the top right corner of the the first column counting from the left.
    Ron Cuderre posted a template on some site called contextures but I can't do it by myself.

  • RELEVANCY SCORE 2.80

    DB:2.80:Data Problem In Discoverer Crosstab d9


    In a Crosstab, I've got two calculation columns(including division like 'columnA/columnB')

    When a node is collapsed, the data in these two columns is ok
    When I unwrap this node(parent), its child-node's data is ok, but the parent-node's data in the columns mentioned above would become '999999.....'

    Is it about the settings of the Database?
    How can I solve this kind of problem?

    DB:2.80:Data Problem In Discoverer Crosstab d9

    Hi,

    Are you sure you're not using detail data points in your cross-tab, but group functions (like SUM or MAX)? This might cause the issue.

    Michael

  • RELEVANCY SCORE 2.80

    DB:2.80:Merging Two Columns From Two Data Tables. xc


    hi,
    I have two data tables
    1.DataTable1 containing columns One,Two and Three
    2.DataTable2 containing columns One,Two and Four
     
    I would like to Merge the  2nd Table with the first table with the values. in the format of

    One | Two| Three | Four
    When i try to merge those tables with DataSet.Merge() and DataTable.Merge() method, the columns only gets added and not the values in it.
     
    Could any one tell me the solution to perform the same with a code snippet
     
    Thanks in advance.
     
     
     

  • RELEVANCY SCORE 2.80

    DB:2.80:Radio Button Of Two Columns To Be Grouped fz



    Dear Experts,

    I have a table with columns like SUBSCRIBE and UNSUBSCRIBE which are wdy_boolean data type and displaying as radio buttons.

    The problem is both columns are displaying as selected and want to make these two columns as group so only one can be selected.

    I mapped cell variant with other column but its not hit.

    Please suggest.

    Thanks Regrads

    Siva Mandapudi.

    DB:2.80:Radio Button Of Two Columns To Be Grouped fz


    Dear Saravanan,

    Your suggestion is excellent. Its hit.

    Rewarded full points.

    Thanks Regards,

    Siva Mandapudi.

    Edited by: SIVAMANDAPUDI on Jul 15, 2011 8:09 AM

  • RELEVANCY SCORE 2.79

    DB:2.79:Cycle Counting sj



    Hello

    __Before execute LX26__

    I maintain cycle counting indicators (A ,B for two material)for two material the"Cycle Counting" under Physical Inventory in the Inventory Management cycle counting indicators.

    I maintained the cycle counting indicator (for example, A, B or C) into the "Storage" view of the material master record.

    I configured on Activities Inventory Define types per storage type section CC (cycle counting) for the storage types where cycle counting is to be implemented.

    I Choose Physical Inventory Physical Inventory Document Create Cycle counting from the WM menu bar and Enter the warehouse number, storage type, and the time interval (in the "Inventory Period" field) for the inventory. Choose Execute.

    I updated the stock in the inventory for both material which needs to for counting before run the transaction code-LX26

    __After execute LX26__

    No data exist(select again)

    DB:2.79:Cycle Counting sj


    Hello,

    ABC indicator defines at which time intervals a physical inventory is to be carried out for the material.

    May be your material is not in due for cycle counting based on the indicator.

    Please do the change the interval dates in Tcode: OMCO ("SETTING FOR CYCLE COUNTING")

    and then see the materials are in due list for the counting through LX26.

    If you want the system analyse the indicators then use MIBC.

    I think for your case due dates are not matched to get the records shown in LX26.

    thanks

    tkreddy

  • RELEVANCY SCORE 2.79

    DB:2.79:Counting Columns In Ascii Text File To Enter Data Into An Array ca


    Hi, I am using visual basic 2008 and trying to create an application to plot data from text files. I have several data files of various sizes. They have an unknown number of rows and either 2 or 4 columns. I need to put the data into 2 dimensional array, so value(,) becomes either value(lines,3) or value(lines,1) depending on the number of columns. My program needs to be able to count how many columns there are, and redim value(,) appropriately. I have written a piece of code to count the number of lines (rows) in the file using 'While not (EOF(1)) ....' but I'm stuck on how to count the number of columns. I could ask the user to indicate how many columns there are before the file is read, but I would prefer the program to detect the number automatically. Thanks for your help!

    DB:2.79:Counting Columns In Ascii Text File To Enter Data Into An Array ca

    ReadAllLines and then split on your column separator.  Store the result in a List(of string()).

  • RELEVANCY SCORE 2.79

    DB:2.79:How To Compare A Day's Value With Yearly Averages? fp



    What I have is a table with 3 columns: clus_name, number_trans and date - indicating the amount of completed transactions by a server cluster on a given date.

    What I want is to create a bar diagram where for each cluster I have 3 bars:

    1. number of completed transactions on some date D

    2. average number of completed transactions of the past year, starting from D

    3. same as 2, but only counting those dates with the same day as D, that is only counting mondays if D is a monday etc.

    Point 1 is already done, it's 2 and 3 I'm after.

    /Edit: I've now attached an example document, containing data for 3 clusters over 3 years and the unfinished diagram.

  • RELEVANCY SCORE 2.79

    DB:2.79:Question On Ni Pcie-6320 Events Counting 8z



    Hello, all:

    I am using 6320 for digital events counting. I am using a gated buffer counting method. At the end of each counting period, I read all buffered events out to get their timestamps. However, there is a problem with this method. When the events number exceed 1 million (?), all buffered events lost and I can not read out anything. My guess is this is due to buffer size or counting clock rollover. (?) There are basically two ways to overcome this problem. One is to do multiple events reading and the other is prescale the events. Does anything know how to perform prescale counting?Forexample I may justcount the timing ofevery fifth event.

    My counting method was be seen in the attached vi.

    Thank you.







    Solved!
    Go to Solution.

    DB:2.79:Question On Ni Pcie-6320 Events Counting 8z


    Thanks Kevin for your answer. I changed the default buffer size and the problem solved.

    Lixin

  • RELEVANCY SCORE 2.79

    DB:2.79:Count Unique Values And Unique Text Comparing Two Columns pj


    I have two colums, one is an ID and the other is a Name. I want to count only the Unique ID and Unique Name, without counting Multiple IDs of the same Name

    Example...

    Column
    A B
    ID Name
    1111 Test
    1111 Test 1
    1111 Data
    1112 Data 1
    1112 Data 1
    1112 Test
    1113 Test
    1113 Test
    1113 Test
    ...

    Count should be 6.... Dont want to count multiple Names or blanks of the same ID

    Thanks so much in advance!!

    DB:2.79:Count Unique Values And Unique Text Comparing Two Columns pj

    Hi,

    May I request you to post your question in the Comments section of this link -

    http://www.ashishmathur.com/count-uniques-with-conditions/#comments

    Thank you.

  • RELEVANCY SCORE 2.79

    DB:2.79:New Requirement In Web Analysis 9z


    Hi Experts,
    We are designing a new Chart report in Web analysis, in "Rows" their are three members and the "Columns" contain two members.
    Our Client requirement is that Two specific Dimension members Of "Rows" should show Data specific to One dimension member of "Columns" and One specific Dimension members Of "Rows" should show Data specific to One dimension member of "Columns".
    Is it possible?
    Can Anyone please help on this.

    Regards,
    ACE

    DB:2.79:New Requirement In Web Analysis 9z

    Got the answer!

    It is calculated through 'Analytical Tool Manager'.

  • RELEVANCY SCORE 2.78

    DB:2.78:Counting Data xz



    Hi,

    May I ask a counting issue as follow:

    I have monthly data for 2 columns A and B.

    in the table, I check every month:

    If A 0

    -if A B then value = 1 else value =2

    If A0

    -if A B then value = -1 else value =-2

    I want to find the total numbers of -2, -1, 1, 2 for all time period in Chart (not in script, since B is choosen by users).

    How can I write the formula?

    regards,

    Ivan

    DB:2.78:Counting Data xz


    Thanks for both Karl and John. It is working fine. cheers!!

  • RELEVANCY SCORE 2.78

    DB:2.78:Adding New Data Column x8



    Hey guys, I have a novice question for ya. I'm reading 4 analog channels and writing all four of them to a file in four columns. A part of my program is counting the number of digital (TTL) highs and indicating a "cycle count" with a shift register. I'd like to put this "cycle count" as a new column in my data file, alongside the other 4, preferably in the first column. I've tried to wire the count directly to the measurements VI, but it's not separating it into it's own column... any ideas?







    Solved!
    Go to Solution.

    DB:2.78:Adding New Data Column x8


    Yes, the cycle count does go up in cross' case. I'm trying to collect a sine wave and I have a cycle counter. I want to output the count of the current data being measured to my file... so it would look something like this...

    1 xxx xxx xxx

    1 xxx xxx xxx

    1 xxx xxx xxx

    2 xxx xxx xxx

    2 xxx xxx xxx

    2 xxx xxx xxx

    3 xxx xxx xxx

    3 xxx xxx xxx

    3 xxx xxx xxx

    The x's being my analog channels and the left most column is my cycle count...

  • RELEVANCY SCORE 2.78

    DB:2.78:Counting Two Columns Of Data 8x


    Hello,

    I have a spreadsheet with account names incolumn Aand the year the account ran inColumn B. There are over 260,000 entries in column A and only six unique entries in column B (years2008through 2013).

    The 260,000 account names incolumn A are not unique. there are many duplicates. For example let's say theXYZ Corp had 500 orders in 2013, 650 orders in 2010 and 50 orders in 2008.

    I would like to create a pivot table pivotthat shows how many years each account placed orders, not the total numbers of orders. For example, I would like to show the number "3"for theXYZ Corp. because they placed orders in three years. Whenever I use
    the "Count" value setting in my pivot table, it shows the total number oforders placed not the total years.

    Can I accomplish this in the pivot table or do I have to add another column of data that counts the number of years before I pivot?

    Any help would be greatly appreciated.

    Thanks.

    Chris

    DB:2.78:Counting Two Columns Of Data 8x

    Benishiryo,

    Thank you for responding to my request. Unfortunately, I am using Excel 2007. The company I work for is very slow to invest in software upgardes. It makes my job challenging.

    Thanks anayway.

    Chris

  • RELEVANCY SCORE 2.78

    DB:2.78:How Can I Read A Counter Value For Two Edge Separation Before Counter Is Stopped By Second Edge (6602 Board)? 3a



    I am using a 6602 counter timer/board with DAQmx. I am using the two-edge separation counting available through DAQmx. The counting between the two edges works properly, however I do not know how to read the value of the counter during the counting operation (i.e.after the first edge has triggered the start of counting but before the second edge has triggered the end of counting). I am having to wait until the second edge triggers the end of counting before I can get a counter value. I need to be able to access the current value of the count during the counting operation. This was possible in traditional DAQ. How can it be accomplished using DAQmx?







    Solved!
    Go to Solution.

    DB:2.78:How Can I Read A Counter Value For Two Edge Separation Before Counter Is Stopped By Second Edge (6602 Board)? 3a


    John,

    Your point about the pause trigger approach continuing to increment is well taken. However, my second edge will not be toggling until after I have read the final results from the counter. This approach allows me to dispense with buffering, so I will do that until compelled to do otherwise.

    --Ray

  • RELEVANCY SCORE 2.78

    DB:2.78:Joining Two Data Sources On Multiple Columns p9


    Hi,

    I am using BI Publisher 11g (11.1.5) and creating a data model by pulling multiple data sets. One data set is coming from OBIEE and another is from MS Excel. I need to join these two data sources on multiple columns. For example OBIEE source has two columns (region and customer #) and excel has to columns (regionName and Customer Num). When I am creating the links using these two columns I do not see any data generated in the XML output. I have manually checked that the data is matching in excel file with those coming out of OBIEE.

    IF I join using a single coloumn (for example Region) then XML returns the data but not with two column joins. Is there any restriction of joining two data sets on a single column only?

    Thanks in advance

    Devang

    DB:2.78:Joining Two Data Sources On Multiple Columns p9

    I have figured it out. If you have mutiple columns to join then establish the relationship by creating the join at Element level link and not at Group level link. You can cliclk on the "" option and pick create link option. Repeat the steps for as many columns as you want to establish the join criteria.

    Regards

  • RELEVANCY SCORE 2.77

    DB:2.77:Cats Question - Remove Time Columns 9a



    In CAT2 for the data entry section I got three columns for every day, one for hours and another two for time.

    How can I get rid of two time columns? I have disabled many fields, but those columns are still there...

    Many thanks for your help.

    DB:2.77:Cats Question - Remove Time Columns 9a


    HI,

    If ur using CATS Classic,

    Try this!!

    Time Sheets, Specific Settings for CATS regular,CATS regular,Record Working Time, Define Field Selection, Settings,

    With clock times -

    MAKE IT AS HIDDEN

    Hope this will definitely help u

  • RELEVANCY SCORE 2.77

    DB:2.77:Access 2007: Counting Unique Records In A Form Using A Text Box pf


    In Access 2007: I have a form with qry data displayed on it. At the top of the form are buttons that are used to filter the data. Two of the fields are Parent_ID and Child_ID, with Child_ID being a subset of Parent_ID. This relationship obviously causes the Parent ID to repeat. I need to get the numberofParent_IDs.

    DB:2.77:Access 2007: Counting Unique Records In A Form Using A Text Box pf

    To get the number of ParentIDs ina tableselect count(distinct(ParentID)) as NumberOfParents from myTablePremature optimization is the root of all evil in programming. (c) by Donald Knuth
    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog

  • RELEVANCY SCORE 2.77

    DB:2.77:Column Having Minimum Value Of Two Calculated Columns f3


    Hi All

    Please help me out in the following scenario.

    I have to get the data from two tables so whatever columns I need put it in the select statement but for two columns I have to do calculations and did assigned an alias name to those two calculated columns, lets say X Y.

    I have to show the data for column Z, the rule for this column is to take minimum value of columns X Y.

    I have to use purely a select statement and retrieve the data. Camnt do any changes or creating functions on database.

    thnaks in advance.

    DB:2.77:Column Having Minimum Value Of Two Calculated Columns f3

    @Sven

    First thought is using minimum function and throwed me error and then realized that min function can be used on a column and then searched for function to find minimum of calculated columns, could n't find out.

    Then thought of using case or if statement to find out the minimum, felt thats not a good idea and also thought of using nested sub query, could n't achieve the desired.

    Actually I didnt know about the least function, now I

    Anyway thnak you all.

  • RELEVANCY SCORE 2.77

    DB:2.77:Can A Table Span Multiple Columns In Pages 18


    In Word I can create a document with two columns (I am referring to the columns in text portion of the document not columns in a table), then place a table in it and the table will automatically distribute itself between the two columns. For instance if there are 5 rows of data plus a header row the table on the left column will contain the header row and the first three rows of data. The right column will contain a table with the header row plus the last two rows of data. Is this possible in Pages?

  • RELEVANCY SCORE 2.76

    DB:2.76:How To Fill A More Than 3 Columns Of Data Into A Listbox In Vb.Net 8j


    Hello
    Fill List Box With Data From Two Or More Columns

    how to fill listbox with data from two or more columns ? (I need to load my 5 columns datas into a Single column Listbox in vb.net)

    DB:2.76:How To Fill A More Than 3 Columns Of Data Into A Listbox In Vb.Net 8j

    Hello,
    AestheticallyCor and Frank suggestions are the optimal way for a good user experience.Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem.

  • RELEVANCY SCORE 2.76

    DB:2.76:Count The Number Of Records If A Criteria Is True In Either Or Both Columns xd


    Hello,

    I am trying to count records if"yes" statementsappear in two different columns for a single record. I would like to count a record if "YES" appears in either column or both columns, but the record will be counted once even if "YES" appears in both columns,
    i.e. I'm not simply counting the number of times "YES" appears in two columns. For example:

    A B
    NO NO -- do not count
    YES NO -- count as 1
    YES YES -- count as 1
    NO YES -- count as 1
    NO NO -- do not count

    I would like the total count to appear in a specific cell.

    Thanks in advance.

  • RELEVANCY SCORE 2.76

    DB:2.76:Count When Two Or Three Columns Meet Specific Data Requirements aj


    I have 1000's of rows of data - need to countrecords where I find a fr in column 1 and A 2 in column B

    DB:2.76:Count When Two Or Three Columns Meet Specific Data Requirements aj

    Hi,

    Try this

    =SUMPRODUCT(($A$2:$A$1000="fr")*($B$2:$B$1000=2))

    Hope this helps.

  • RELEVANCY SCORE 2.76

    DB:2.76:Count Non Blanks Across Multiple Columns 7k



    Hi,

    I am a SAS beginner that has just started with EG 4.2, so feeling my way around.

    I have a table of data where the are multiple columns and I would like to count the number of non blank columns in each row and store the count into a new calculated column. So my outcome should looks like this;

    IDCo1Col2Col3Col4New Column: Count of Non Blanks1001XX21002X1234abc31003X1

    I've not been able to find any guidance on how to do this type of counting using EG query builder so if anyone could help that would be fab!

    JW

    DB:2.76:Count Non Blanks Across Multiple Columns 7k


    Ok. Note, you would need to have all variables of the same type, e.g numeric. Otherwise its more complicated as you have to do the code twice, first to convert text to number.

    You can pre-fill some macro variables and then use those, something like:

    proc sql noprint;

    select NAME

    into :LIST separated by ' '

    from SASHELP.VCOLUMN

    where LIBNAME="WORK"

    and MEMNAME="HAVE"

    and index(NAME,"2014")0;

    select count(NAME)

    into :LIST_COUNT

    from SASHELP.VCOLUMN

    where LIBNAME="WORK"

    and MEMNAME="HAVE"

    and index(NAME,"2014")0;

    quit;

    Then, same as before, but using these macros:

    data want;

    set have;

    new_col=0;

    array items{LIST_COUNT.} LIST.;

    do i=1 to LIST_COUNT.;

    if items{i}=0 then new_col=new_col+1;

    end;

    run;

  • RELEVANCY SCORE 2.76

    DB:2.76:Total Formual Field Counting Supressed Numbers 93



    Hello,

    I am using CR 2008. I have two fields, Quoted Price and Quantity Order which I made a summary field ({Table.QuotedPrice}) * ({Table.QuantityOrder}); which works great. My issue is I have a Total field that I made trying to sum up all the summary field in the details part of the report. Unfortunately the Quoted Price field and Quantity Order fields have duplicated data in the tables so I I have to check the box; Suppress If Duplicated. The Total summary field is still summing up the suppressed columns which is giving me the wrong total. Not really sure how to fix this issue. Thanks in advance, Eric

    DB:2.76:Total Formual Field Counting Supressed Numbers 93


    Hi Abhilash,

    100% solved my issue! Thank you so much.

  • RELEVANCY SCORE 2.76

    DB:2.76:Vlookup 8z



    Hello,

    I have two tables, one with 2 columns and other with 3 coulmns. In second table 1 coulmn in merger of columns of first table. We want to combine the two tables in a way that first table-two columns and second tables 2 two columns come together. The column which is merger of two columns of will not be in the output but the data maps correctly.

    We have tried to do this with help of two join. However is there any other optimal solution ?

    Please find attached example for same.

    Thanks,

    Nish

    DB:2.76:Vlookup 8z


    Thanks Mohit,Deepak and Martyn.

    Nisha

  • RELEVANCY SCORE 2.76

    DB:2.76:When I Resort My Set Of Data, The Old Charts Are Recast. xc


    I have a set of data with many columns. I want to make scatter plots of 2 of the columns- say columns r and s. After finishing one chart, I want to resort two different columns in my data set and make a new chart - say columns c an d. When I do that,
    the original chart is compromised, i.e, completely gone or redone. How do I prevent this?

    DB:2.76:When I Resort My Set Of Data, The Old Charts Are Recast. xc

    Does it happen with specific file?
    Do you face the same issue if you create different chart instead of scatter chart?
    Create a new excel file and check if the chart options works fine?

  • RELEVANCY SCORE 2.76

    DB:2.76:Sumproduct Of Two Columns Based On Criteria In Third Column kx


    Hi,

    I am trying to return the sumproduct of values in columns AJ and AQ on my data sheet if the values in column J on the data sheet match cell E3,
    I have the following but am getting an error message

    =SUMPRODUCT((data!J:J=E3)*(data!AJ:AJ)*(data!AQ:AQ))

    DB:2.76:Sumproduct Of Two Columns Based On Criteria In Third Column kx

    kliddicoat wrote:

    I am trying to return the sumproduct of values in columns AJ and AQ on my data sheet if the values in column J on the data sheet match cell E3, I have the following but am getting an error message
    =SUMPRODUCT((data!J:J=E3)*(data!AJ:AJ)*(data!AQ:AQ))

    Would have been nice if you provided us with the error message. I am going to guess it is a #VALUE error. The following might avoid that:

    =SUMPRODUCT(--(data!J:J=E3),data!AJ:AJ,data!AQ:AQ)

    The double-negative (--) converts the logic values TRUE and FALSE to 1 and 0, which SUMPRODUCT needs in order to behave as intended.

    But it is "poor practice" to use column ranges like J:J. In Excel 2007 and later, it causes SUMPRODUCT to process 1+ million rows, in this case creating an array of over 1+ million elements, too.

    It would be better to specify limited ranges like J1:J100000. It is very rare that we might actually have 1+ million rows of data.

  • RELEVANCY SCORE 2.75

    DB:2.75:Two Files Merging Using File Adapter In Bpel 2.0 x8


    Hi All,I have two different files (File 1 and 2) of same format(Two columns each) , now i want to merge these two files using their data and form a consolidated file (File 3 with four columns).Please advise on how to make it possible using file adapter.Example:File 1 Format: A1 and A2 - are two columns of number and sring typeFile 2 Format : B1 and B2 - are two columns of number and string typeConsolidated File 3 Format : A1 B1 A2 B2 - forming a single row if A1=B1 and also populating A2 and B2.ThanksKarthick.

    DB:2.75:Two Files Merging Using File Adapter In Bpel 2.0 x8

    Hi Karthick,I would say read both files completely. Then create a transform and select both messages as an input creating one output. With XSLT it should not be too hard to combine the two inputs. You could loop on one file and then select each row from the other file. That output can be written to file.I don't know what triggers the process, but you could either let bpel be triggered by the polling on one file and read the other synchronously. Or read both files synchronously.Regards,Martien

  • RELEVANCY SCORE 2.75

    DB:2.75:Not Counting Duplicate Names During A Certain Month. jz


    I have two columns, One with a name another with a date.
    I would like to count the number of names once with in a certain date.

    Ivie shows up three times in this data set. I just one to count it once.

    The formula I am using looks at the date only.
    =COUNTIF($D$2:$D$5000, " " DATE(2010, 9,1))-COUNTIF($D$2:$D$5000,"" DATE(2010,8,1))

    Is there away to do this?
    Nancy

    DB:2.75:Not Counting Duplicate Names During A Certain Month. jz

    You could try filtering the data between Dates then use a formula to evaluate the details. Use the Between function to filter the dates. I actually copied the filtered data to a new location and used the following formula:

    =SUM(IF(FREQUENCY(MATCH(F23:F27,F23:F27,0),MATCH(F23:F27,F23:F27,0))0,1))

    Hope this helps

  • RELEVANCY SCORE 2.75

    DB:2.75:Counting Unique Records 8p


    Below is some data. My goal is to count the unique number of records.
    I know the below formula counts how many unique neighborhoods are in California:

    Can someone tweak this formula that provides me the number of unique States, Cities, and Neighborhoods? In other words I want a formula that will provide me the number of unique records of columns A through C. As always, I appreciate your help

    DB:2.75:Counting Unique Records 8p

    State

    Cities

    Neighborhoods

    Washington

    Seattle

    Space Needle

    California

    San Francisco

    Downtown

    California

    San Francisco

    Downtown

    California

    San Francisco

    Sunset

    California

    San Francisco

    Sunset

    California

    Boulder Creek

    Big Basin

    California

    Woodside

    Kings Mountain

    Florida

    Miami

    Beach

    Florida

    Orlando

    Disney

    Try this array formula**:
    =SUM(IF(FREQUENCY(MATCH(A2:A10B2:B10C2:C10,A2:A10B2:B10C2:C10,0),ROW(A2:A10)-ROW(A2)+1),1))
    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.

  • RELEVANCY SCORE 2.75

    DB:2.75:Delete Only Two Specifc Columns Of A Dso And An Infocube z7


    Hi all , Is it possible to delete the data from only two fields of an Infocube or an ODS( Do remember that the Two columns should be displayed empty in the List output. If it is possible please suggest me the navigation .Thanks in advance.

  • RELEVANCY SCORE 2.75

    DB:2.75:Filter Data In Query Designer For Max Value x1


    Im using Report Builder 3.0. I'm new to this so I need a lot of help :)
    I am creating my dataset and in the Query Designer, I want to filter my data to only showthe most recent date in the [Last Update Date] and [Created Date] columns for each [Work Item ID]
    As you can see in the above example, there are two rows with identical [Last Update Date]. I only want to show one of them.

    I thought about using the mostrecent[Created Date] but some of the data also have identicaldate/time.
    In my other report, I grouped the data in my tablix by [Work Item ID] then filter the data by [Last Updated Date] but running the report takes a lot longer so I was thinking if there's a way I can filter my query first if it makes a difference. Also,
    with grouped/filtered tablix, I cant figure out how to count the rows based on the grouped/filtered values. It keeps counting the data from the dataset.

    Also, after I selected my fields via Query Designer, the Query box displays the code in XML:

    SemanticQuery xmlns=http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling xmlns:xsd=http://www.w3.org/2001/XMLSchema xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xmlns:rb=http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder xmlns:qd=http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign
    Hierarchies
    Hierarchy
    BaseEntity
    !--Tbl Work Item Assignment--

    Thank you for your help.

    DB:2.75:Filter Data In Query Designer For Max Value x1

    Yes, I tried a simple select statement before and got an error message (Failed to prepare query. (Microsoft.ReportingServices.DataExtension). I just tried it againbased on the above link and gotthe sameerror message. Im using
    SQL 2008 R2 Report Builder 3.0.
    I was told'our' Report Builder uses XML not SQL -- I really dont know what that means or why.

    USE SampleAdHoc;
    Go
    SELECT Work_Item_ID, Created_Date
    FROM Tbl_Work_Item_Assignment
    WHERE Work_Item_ID IS NOT NULL;

  • RELEVANCY SCORE 2.74

    DB:2.74:Comparing Data In Cells Of Two Columns j1


    https://skydrive.live.com/redir?resid=849E1B00B33DEEFD!218

    DB:2.74:Comparing Data In Cells Of Two Columns j1

    Hi,

    Try this

    1. Select A2:A478, press the Ctrl key and then select B2:B2579
    2. Go to Home Conditional formatting New Rule Format only Unique or Duplicate Values Duplicates
    3. Click on Format and choose any Fill colour
    4. Click on OK/Apply

    You may now filter on either column on colour Red.

    Hope this helps.

  • RELEVANCY SCORE 2.74

    DB:2.74:How To Limit No Of Columns In Data Load Wizard s8


    Hi,

    I have created small application by using data load wizard and it is working fine. My destination table has total 5 columns and out of 5 columns, two columns are populate through default value (Username and sysdate) so actual data store in only three columns. But in the wizrd run, in table/data mapping it gives me all 5 columns, is there any way to reduce only three column?

    thanks
    Dax

    DB:2.74:How To Limit No Of Columns In Data Load Wizard s8

    Dax,

    Look for drop-down that indicates that the column should not be uploaded.

    Jeff

  • RELEVANCY SCORE 2.74

    DB:2.74:Delete Every 5th Column a1


    Hi,

    I posted a similar question but after hours spent trying to modify the VB I couldnt, so am asking for help again.

    Im looking for some VB that will starting in column G, I want to delete the next two columns (ie H and I), then skip over 5 columns and delete the next to columns (prior to deletion will beO and P) and then skip over 5 columns and delete next two columns
    (prior to previous two deletions will beV and W) etc for say 160 columns worth of data.

    Regards

    Darin

    DB:2.74:Delete Every 5th Column a1

    at least mark my reply as useful.
    I'm trying to show you how to work around based on bits of what people help you. Basically to copy and paste and assemble the codes around by changing small variables to fit your needs.

    thank you.Please do not forget to click “Vote as Helpful” if the reply helps/directs you toward your solution and or Mark as Answer if it solves your question. This will help to contribute to the forum.

  • RELEVANCY SCORE 2.74

    DB:2.74:Dynamic Column In Table fc



    I wonder how to make a dynamic table depending on the number of selected data. Example: counting the total sales in the month. I would like to be shown in the columns of months, depending on the date range.

    example 1

    Scope of the date of January 1, 2014 to March 31, 2014

    ProductJanuary 2014February 2014March 2014Car12562,32456543,4585266,32

    example 2

    Scope of the date of 1 November 2013 to 31 March 2014

    ProductNovember 2013December 2013January 2014February 2014March 2014Car124564,32456463,14146232,23456,361456,36

    DB:2.74:Dynamic Column In Table fc


    Take a Straight table or a pivot table

    Dimension:-

    Product

    Month Year

    Expression :-sum(Sales)

    Take a snap shot for that

  • RELEVANCY SCORE 2.74

    DB:2.74:Problem With Place Holder Columns pk


    Hi,

    In Report data model I have taken two place holders columns. At run time if values are null for a particular customer then these two place holder columns are taking previous values of another customer.

    Could you help me how to solve this problem?

    Thanks in advance.

    DB:2.74:Problem With Place Holder Columns pk

    Hi,

    Did you place the placeholder column inside the group or its just outside.

    The purpose of placeholder column itself is to store values. To, calculate values or display based upon query only formula columns are used. That is the only reason we base the display attribute on formula column then placeholder.

    what you need to do is, make the source of ur display as formula column and in the program unit of formula column check for the condition and then return the value of placeholder accordingly.

    Hope this helps.

  • RELEVANCY SCORE 2.74

    DB:2.74:Relating Two Columns Of Data In Excel ax


    Is there a formula I can use to relate 2 columns of information?
    I have one column indicating income and the other column indicating the corresponding family size. I need to put this data into a table arranged by income range and family size.

    DB:2.74:Relating Two Columns Of Data In Excel ax

    This was very helpful in creating a pivot table, but I am having trouble grouping the data. I have tried highlighting it so that I can select group field but no matter what I do group field always remains gray and unable to use. Any suggestions?

  • RELEVANCY SCORE 2.74

    DB:2.74:How To Merge 2 Columns Of Jtable? m8


    Hi All,
    Is there any way to merge two or more columns of a table and merging them into one column.And the data in the columns should be combined and should be shown in one column.
    Thanks in advance.

    DB:2.74:How To Merge 2 Columns Of Jtable? m8

    Shanmukhi wrote:
    Hi All,
    Is there any way to merge two or more columns of a table and merging them into one column.And the data in the columns should be combined and should be shown in one column.
    Thanks in advance.What do you mean by "combined"?

    It sounds like you're going to want to use a custom table model. Check out the JTable [tutorial |http://download.oracle.com/javase/tutorial/uiswing/components/table.html] for more information. You also might want to check out the [TableColumnModel |http://download-llnw.oracle.com/javase/6/docs/api/javax/swing/table/TableColumnModel.html] API for useful functions.

  • RELEVANCY SCORE 2.73

    DB:2.73:Two Source Buffered Counting xk


    I'm working with a buffered counting program that takes the imput from
    two different sources and displays the counts as a function of
    time. The other day I did a test and realized that the time axis
    for these two counters is not synchronized. The program was
    written by a visiting student and basically from files and subvis taken
    from the labview code sharing. Basically, its two individual
    buffered counting programs running in parrallel and their is no
    connection between the two. I have tried several things including
    using the time data from one for both sources and many other simple
    things. I'm not very experienced with labview but I'm reading up
    and it looks like I may need to use a trigger to synchronize the
    counting. It would be nice if anybody can help me with this
    problem? I'm using the 6602 in traditional NiDaq mode.

    Message Edited by Briconn on 01-12-2006 12:54 PM

    DB:2.73:Two Source Buffered Counting xk


    Hi Bri,

    My bad .... i posted the wrong link

    The correct link to the example code is http://sine.ni.com/apps/we/niepd_web_display.displ​ay_epd4?p_guid=B45EACE3DC9F56A4E034080020E74861p_​....

    Sorry about that, I didn't realize my error until I posted the response.




    Regards,Natasa

  • RELEVANCY SCORE 2.73

    DB:2.73:Gated Counting Issue zz


    I am having trouble with gated counting in my program.First off I am using Labview 7.1 and NI-DAQ 6.9.2 with a PCI-MIO-16XE-10 and a PC-TIO-10.The vis were written for us by an outside firm many years ago. They were unable to create a proper gated counter. Instead we count for 10 30ms bins and externally gate our PMT signal with an AND gate.It appears that the program does not remove the first value in the buffer. So we see non-sense data in the first bin of our histogram. This problem was greatly accentuated when we upgraded to Labview 7.1. So, much infact we have reverted to the 6.1 version of the program. The issue is still there but does not occur as often.I have been tasked with fixing the problem. Rather than just counting for an extra bin and removing the first, I would like to convert the system to a proper gating counter.The system will ideally create a 4Khz trigger for our laser then remove the laser pulse with a 12 usec gate. Leaving us with a 238 usec counting window. We also have two shutter signals that fire for 300 msec each. I would like to be able to arm the counter. Then start and stop it with one of the shutter signals. The start of the shutter signal will be software controled. Then extract an array of the counting windows from the buffer.The TIO-10 will do all the timing and the MIO will do the counting. We are not able to upgrade these systems at this time so we must use these boards.Any input on examples of where I should start will be greatly appriciated.

    DB:2.73:Gated Counting Issue zz

    Ok, it's been a while since I used a PC-TIO-10 and even then I didn't explore it all that much (mainly continuous pulsetrains and period measurement, which worked kinda weird). I'll try to work through a method that doesn't involve changing boards, but if you *could* change boards, you could then use new features in DAQmx which allow you to simultaneously perform logical-AND-style gating and buffered-sampling-style gating. With traditional NI-DAQ it's got to be one or the other.Toward the end of your message, you mention expecting an array containing 1200 elements, one per gate period. This suggests that your MIO counter should buffer a count value on each edge of the 4 kHz pulsetrain that occurs while the 300 msec pulse is ON. Is this right? It also sounds like it should only spend 238 usec of each 250 usec gate period actually counting the PMT pulses b/c the first 12 usec should be ignored. Is this right? You said that this gating is accomplished with an external circuit -- are you satisfied with this aspect of gating? For this reply, I'm assuming not.Finally, your PMT pulses are 9 nsec duration. This is slightly less than the 10 nsec pulsewidth spec for edge counting on the MIO card, so you're skating on thin ice in any event.With that combination of requirements, I'm also having trouble finding a solution that doesn't require an external logic circuit. It seems that you're looking to apply 3 different gating operations to a single counter measurement task.1. Buffered-sample gating -- store a count value in a buffer once per falling edge of a 4 kHz pulsetrain.2. Logical-AND gating -- only count during 238 usec of each 250 usec interval.3. Logical-AND gating -- only count and store counts during a 300 msec interval while a pulse is HIGHUnder traditional NI-DAQ (which you're stuck with while using the PC-TIO-10), you can accomplish #3 in the pulse generation task, but you can't program for both #1 and #2. You'll need to accomplish #2 with some simple external logic circuitry -- AND's and NOT's. Here's what I'd do:1. Logically AND the 4 kHz pulsetrain with the 300 msec pulse. Call this the gated laser trigger. You may be able to do this with just the PC-TIO-10 without any external circuit. You definitely can do it with an MIO counter. You would setup the 4 kHz pulsetrain to be "level-gated" by the 300 msec pulse.2. Logically AND the 238 usec portion of the 4 kHz pulsetrain with the PMT pulses using an external circuit. This may require a logical NOT or two along with the AND. Call this the gated PMT.3. Program the MIO counter to perform buffered period measurement. The falling edge of the gated laser trigger (#1 above) would be the "gate" (a.k.a. sampling clock) signal. The rising (maybe falling depending on how you do your logic) edges of the gated PMT pulses (#2 above) would be the source signal.4. Behavior: Every 250 usec during a 300 msec timed interval, a count value will be stored in the buffer. The value of each count will be the # of gated PMT pulses that occurred during the 238 active usec of the most recent 250 usec interval.Again note that ALL of the above could be done with a single 6601 board using DAQmx. 1 counter to generate a 300 msec pulse. 1 counter to generate a 4 kHz pulsetrain only during the 300 msec pulse's HIGH time. 1 counter to buffer counts with the gated 4 kHz pulsetrain acting as both a sampling clock and an active-low pause trigger.-Kevin P.

  • RELEVANCY SCORE 2.73

    DB:2.73:Compare Columns In Two Spreadsheets 31


    I have two spreadsheets the have the same key field in each one. The data is missing from one of the spreadsheets and I need to compare sheet 1 (that should have all the data I need) to sheet 2 (missing data) and produce a report in sheet 3 of the missing
    data

    DB:2.73:Compare Columns In Two Spreadsheets 31

    We need a bit more information before anyone can create a solution for you.

    Howis your data layout in the two sheets, and are you using same layout?

    Where should we look for missing data - in the key field column, or in all columns?

  • RELEVANCY SCORE 2.73

    DB:2.73:Counting Number Of Nulls In Iif Expressions ax


    Hi,
    I have two Date columns DueDateActions and DoneDateAction and i want to count the number of Overdue actions in anIIF expressionwhich is when DueDateActions is less than GetDate() and DoneDateAction is null.egCOUNT(DueDateAction
    TodaysDateand DoneDateAction is null), but i want to just add the three columnstoan existingreport (a)Number of Actions (b) Number of Actions completed (c) Number of Actions Overdue

    2, i want to count all the rows that are notnulls in the DoneDateAction column
    3, Number of Actions (which i think is justcount(ID)) Please correct me if otherwise.

    Thanks
    biroma

    DB:2.73:Counting Number Of Nulls In Iif Expressions ax


    =COUNT(IIF(Fields!DueDateAction.Value NOTHING, 1, NOTHING))Regards,
    Asim Bagwan
    Kindly mark the replies as Answers if they help!

  • RELEVANCY SCORE 2.72

    DB:2.72:Count Of The Number Of Columns 3d


    select count(column_name) from all_tabs_columns where table_name='tablename';

    select count(column_position) from user_tabs_columns where table_name='tablename';

    is a query for counting the number of columns. is there any other way??
    can i query the same table for retriving the number of columns in that table????

    DB:2.72:Count Of The Number Of Columns 3d

    is a query for counting the number of columns. is
    there any other way??DBMS_METADATA http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/general.htm#sthref1986

  • RELEVANCY SCORE 2.72

    DB:2.72:Calculate Difference Between Data In Columns Of Pivot Table. zz



    Hi,

    I want to calculate difference between two columns/dimensions generated in a pivot table.

    Thanks in advance for the help

    Regards,

    Utsav

  • RELEVANCY SCORE 2.72

    DB:2.72:Can Ireport Create A Report With Two Columns Like A Newspaper? zk


    Hi,

    Can iReport create a report with two columns containing different fields?
    One column contains a big image, and the other will contain data from database.
    ________________________________________
    data 1 |
    data 2 |
    ... | Image
    data n |
    _________________ |______________________

    After created two columns, I found the image seems repeatedly showing with each row of data.

    It's urgent. Appreciate your help. Any example?

    gen_rpt

    DB:2.72:Can Ireport Create A Report With Two Columns Like A Newspaper? zk

    Hi,

    Can iReport create a report with two columns containing different fields?
    One column contains a big image, and the other will contain data from database.
    ________________________________________
    data 1 |
    data 2 |
    ... | Image
    data n |
    _________________ |______________________

    After created two columns, I found the image seems repeatedly showing with each row of data.

    It's urgent. Appreciate your help. Any example?

    gen_rpt

  • RELEVANCY SCORE 2.72

    DB:2.72:Combine Text Data From Two Columns 9p


    I have text data in columnA and text data in column B, is there a way of combining both columns into one

    Thanks
    Paul Walsh

  • RELEVANCY SCORE 2.72

    DB:2.72:Counting The Number Of Rows While Verifying The Column Data zx


    Hi,
    I have a csv file, where I need the count based on the column data.
    For instance when I run this command, it returns me all the rows. The Flag is one of the columns in the csv file. I need to count when Flag=KEEPMSG. Any assistance will be appreciated.
    Import-Csv C:\tsr.csv | Measure-Object Flags

    Thanks,
    Arnab

  • RELEVANCY SCORE 2.72

    DB:2.72:Rdl File Tablix Sorting. Dynamical Data Columns. ps


    Hi ,
    we are having Tablix with 5 columns of data. in that first 3 column data is a static and remaining two columns data will be calculated and populated dynamically on the 4,5 column. it is working fine but when i sort the any of the first 3 columns it is showing
    the wrong data in the 4,5 th columns.
    can any one help how to over come this.

    Advance thanks.
    Vijay

    DB:2.72:Rdl File Tablix Sorting. Dynamical Data Columns. ps

    Hi Duan,

    Could you please help me how to resolve this issue.

    Thanks,
    Vijay

  • RELEVANCY SCORE 2.72

    DB:2.72:Counting The Number Of Cvc m9



    Hi,

    The question regarding the counting the number of CVCs,How can i count the number of CVCS in my project.regarding the loading data to Planning area of DP how can i load monthly data to DP.What source i am using for that and which format the data is loaded .

    Thanks

    Prasanna

    DB:2.72:Counting The Number Of Cvc m9


    Hi Prasanna,

    Counting the number of CVC in the system is quite simple. just go to MC62 transaction and click on display CVC and then "no. of combination". This would give u a real time CVC count.

    Regards

    Vaibhav Sareen

  • RELEVANCY SCORE 2.72

    DB:2.72:Help Needed In Writing A Query k1


    I have a table Manifest that contains five columns
    hal,oda,van,mis,stat.
    All the columns are of number datatype.
    Now I need a query that returns me the rows that have data for any two columns out of five.
    ex: If there are sample rows like 1,2,' ',' ',' ' and 1,2,' ',' ',' ' and 4,5,' ' ,' ' ,' ' .
    Here in all the three rows, first two columns are having data. So I need the all the three rows as first two columns are having data.
    How to acheive this..

    Regards
    Raghu

    Message was edited by:
    Raghunadh

    DB:2.72:Help Needed In Writing A Query k1

    with t as (
    select 1 a,2 b,3 c,null d,null e from dual
    union all
    select null,2,3,null,null from dual
    union all
    select null,null,null,null,1 from dual)
    select *
    from t
    where nvl2(a,1,0) +
    nvl2(b,1,0) +
    nvl2(c,1,0) +
    nvl2(d,1,0) +
    nvl2(e,1,0) = 2; A B C D E
    ---- --- --- ---- ----
    1 2 3 null null
    null 2 3 null nullI recommend to use nvl2.

  • RELEVANCY SCORE 2.72

    DB:2.72:Multiple Rows Of Output zj


    Playing with the InsertUpdateDelete Tutorial
    How do I output the data in two or more rows and two or more columns - versus one row two or more columns?

    Thanks...

    DB:2.72:Multiple Rows Of Output zj

    Ok, Thanks..

    However, I am still left with how to display 12 fields from a database select statement.. on one xhtml page..

    Is there a tutorial, example somewhere to show how to "bind" database fields to multiple - another JSF Standard Component such as an - Output Text Field(s).
    example: bind table "taxonomy" field "family" to "outputText1," field "genus" to "outputText2," field "species" to "outputText3" etc.. and table "character" field "exposure" to "outputText10", etc.

    Thanks...

  • RELEVANCY SCORE 2.72

    DB:2.72:If Two Columns Matching Get Third Column Data x1


    Hi All,
    I need to match or compare two columns data with another two columns if both two columns are matching i need to get third column data for that line.

    DB:2.72:If Two Columns Matching Get Third Column Data x1

    Hi,
    I had clearly explained in my previous post,
    IfInvoice Number Due Date mentioned in June 2013 table is there in May 2013 for that Invoice Number Due Date in May 2013 get me Open Amount.
    I need amount mentioned in last column Open amount like below table.
    I think am able to give you clear idea:

    Invoice Number
    Due Date
    Open Amount
    Invoice Number
    Due Date
    Open amount

    18
    31/05/2013
    -72,882
    18
    30/09/2004
    11,580

    21
    31/05/2013
    -6,492
    21
    06/12/2005
    6,060

    21
    10/11/2012
    -2,673
    21
    10/11/2012
    -2,673

    21
    06/12/2005
    6,060
    18
    31/05/2013
    -72,882

    18
    30/09/2004
    11,580
    21
    31/05/2013
    -6,492

  • RELEVANCY SCORE 2.72

    DB:2.72:Why My Score Is Counting Like 11 22 33 44 ? cd



    I think there are two instances of this script in your scene.

    DB:2.72:Why My Score Is Counting Like 11 22 33 44 ? cd


    the object where is the script atacthed is making clones. maybe there is something associated to that?

  • RELEVANCY SCORE 2.72

    DB:2.72:How To Get Payroll Days (Hr Module) 8s



    How do I get the exact counting of payroll days given two dates? What other data of an employee do I need to know (e.g. employee group/subgroup, etc.)? Is there an existing function that returns the value of payroll days?

    Thanks for any reply!

    DB:2.72:How To Get Payroll Days (Hr Module) 8s


    HR ABAP - Payroll

    -

    -

    Database Tables in HR

    Personnel Administration (PA) - master and time data infotype tables (transparent tables).

    PAnnnn: e.g. PA0001 for infotype 0001

    Personnel Development (PD) - Org Unit, Job, Position, etc. (transparent tables).

    HRPnnnn: e.g. HRP1000 for infotype 1000

    Time/Travel expense/Payroll/Applicant Tracking data/HR work areas/Documents (cluster

    PCLn: e.g. PCL2 for time/payroll results.

    Cluster Table

    Cluster tables combine the data from several tables with identical (or almost identical) keys

    into one physical record on the database.

    . Data is written to a database in compressed form.

    Retrieval of data is very fast if the primary key is known.

    Cluster tables are defined in the data dictionary as transparent tables.

    External programs can NOT interpret the data in a cluster table.

    Special language elements EXPORT TO DATABASE, IMPORT TO DATABASE and DELETE

    FROM DATABASE are used to process data in the cluster tables.

    PCL1 - Database for HR work area;

    PCL2 - Accounting Results (time, travel expense and payroll);

    PCL3 - Applicant tracking data;

    PCL4 - Documents, Payroll year-end Tax data

    Database Tables PCLn

    PCLn database tables are divided into subareas known as data clusters.

    Data Clusters are identified by a two-character code. e.g RU for US payroll result, B2 for

    time evaluation result...

    Each HR subarea has its own cluster.

    Each subarea has its own key.

    Database Table PCL1

    The database table PCL1 contains the following data areas:

    B1 time events/PDC

    G1 group incentive wages

    L1 individual incentive wages

    PC personal calendar

    TE travel expenses/payroll results

    TS travel expenses/master data

    TX infotype texts

    ZI PDC interface - cost account

    Database Table PCL2

    The database table PCL2 contains the following data areas:

    B2 time accounting results

    CD cluster directory of the CD manager

    PS generated schemas

    PT texts for generated schemas

    RX payroll accounting results/international

    Rn payroll accounting results/country-specific ( n = HR country indicator )

    ZL personal work schedule

    Database Table PCL3

    The database table PCL3 contains the following data areas:

    AP action log / time schedule

    TY texts for applicant data infotypes

    Data Management of PCLn

    The ABAP commands IMPORT and EXPORT are used for management of read/write to

    database tables PCLn.

    A unique key has to be used when reading data from or writing data to the PCLn.

    Field Name KEY Length Text

    MANDT X 3 Client

    RELID X 2 Relation ID (RU,B2..)

    SRTFD X 40 Work Area Key

    SRTF2 X 4 Sort key for dup. key

    Cluster Definition

    The data definition of a work area for PCLn is specified in separate programs which comply

    with fixed naming conventions.

    They are defined as INCLUDE programs (RPCnxxy0). The following naming convention applies:

    n = 1 or 2 (PCL1 or PCL2)

    xx = Relation ID (e.g. RX)

    y = 0 for international clusters or country indicator (T500L) for different country cluster

    Exporting Data (I)

    The EXPORT command causes one or more 'xy' KEY data objects to be written to cluster xy.

    The cluster definition is integrated with the INCLUDE statement.

    REPORT ZHREXPRT.

    TABLES: PCLn.

    INCLUDE: RPCnxxy0. "Cluster definition

    Fill cluster KEY

    xy-key-field = .

    Fill data object

    ....

    Export record

    EXPORT TABLE1 TO DATABASE PCLn(xy) ID xy-KEY.

    IF SY-SUBRC EQ 0.

    WRITE: / 'Update successful'.

    ENDIF.

    Exporting Data (II)

    . Export data using macro RP-EXP-Cn-xy.

    When data records are exported using macro, they are not written to the database but to a

    main memory buffer.

    To save data, use the PREPARE_UPDATE routine with the USING parameter 'V'.

    REPORT ZHREXPRT.

    *Buffer definition

    INCLUDE RPPPXD00. INCLUDE RPPPXM00. "Buffer management

    DATA: BEGIN OF COMMON PART 'BUFFER'.

    INCLUDE RPPPXD10.

    DATA: END OF COMMON PART 'BUFFER'.

    ...

    RP-EXP-Cn-xy.

    IF SY-SUBRC EQ 0.

    PERFORM PREPARE_UPDATE USING 'V'..

    ENDIF.

    Importing Data (I)

    The IMPORT command causes data objects with the specified key values to be read from

    PCLn.

    If the import is successful, SY-SUBRC is 0; if not, it is 4.

    REPORT RPIMPORT.

    TABLES: PCLn.

    INCLUDE RPCnxxy0. "Cluster definition

    Fill cluster Key

    Import record

    IMPORT TABLE1 FROM DATABASE PCLn(xy) ID xy-KEY.

    IF SY-SUBRC EQ 0.

    Display data object

    ENDIF.

    Importing data (II)

    Import data using macro RP-IMP-Cn-xy.

    Check return code SY-SUBRC. If 0, it is successful. If 4, error.

    Need include buffer management routines RPPPXM00

    REPORT RPIMPORT.

    *Buffer definition

    INCLUDE RPPPXD00.

    DATA: BEGIN OF COMMON PART 'BUFFER'.

    INCLUDE RPPPXD10.

    DATA: END OF COMMON PART 'BUFFER'.

    *import data to buffer

    RP-IMP-Cn-xy.

    ....

    *Buffer management routines

    INCLUDE RPPPXM00.

    Cluster Authorization

    Simple EXPORT/IMPORT statement does not check for cluster authorization.

    Use EXPORT/IMPORT via buffer, the buffer management routines check for cluster

    authorization.

    Payroll Results (I)

    Payroll results are stored in cluster Rn of PCL2 as field string and internal tables.

    n - country identifier.

    Standard reports read the results from cluster Rn. Report RPCLSTRn lists all payroll results;

    report RPCEDTn0 lists the results on a payroll form.

    Payroll Results (II)

    The cluster definition of payroll results is stored in two INLCUDE reports:

    include: rpc2rx09. "Definition Cluster Ru (I)

    include: rpc2ruu0. "Definition Cluster Ru (II)

    The first INCLUDE defines the country-independent part; The second INCLUDE defines the country-specific part (US).

    The cluster key is stored in the field string RX-KEY.

    Payroll Results (III)

    All the field string and internal tables stored in PCL2 are defined in the ABAP/4 dictionary. This

    allows you to use the same structures in different definitions and nonetheless maintain data

    consistency.

    The structures for cluster definition comply with the name convention PCnnn. Unfortunately,

    'nnn' can be any set of alphanumeric characters.

    *Key definition

    DATA: BEGIN OF RX-KEY.

    INCLUDE STRUCTURE PC200.

    DATA: END OF RX-KEY.

    *Payroll directory

    DATA: BEGIN OF RGDIR OCCURS 100.

    INCLUDE STRUCTURE PC261.

    DATA: END OF RGDIR.

    Payroll Cluster Directory

    To read payroll results, you need two keys: pernr and seqno

    . You can get SEQNO by importing the cluster directory (CD) first.

    REPORT ZHRIMPRT.

    TABLES: PERNR, PCL1, PCL2.

    INLCUDE: rpc2cd09. "definition cluster CD

    PARAMETERS: PERSON LIKE PERNR-PERNR.

    ...

    RP-INIT-BUFFER.

    *Import cluster Directory

    CD-KEY-PERNR = PERNR-PERNR.

    RP-IMP-C2-CU.

    CHECK SY-SUBRC = 0.

    LOOP AT RGDIR.

    RX-KEY-PERNR = PERSON.

    UNPACK RGDIR-SEQNR TO RX-KEY-SEQNO.

    *Import data from PCL2

    RP-IMP-C2-RU.

    INLCUDE: RPPPXM00. "PCL1/PCL2 BUFFER HANDLING

    Function Module (I)

    CD_EVALUATION_PERIODS

    After importing the payroll directory, which record to read is up to the programmer.

    Each payroll result has a status.

    'P' - previous result

    'A' - current (actual) result

    'O' - old result

    Function module CD_EVALUATION_PERIODS will restore the payroll result status for a period

    when that payroll is initially run. It also will select all the relevant periods to be evaluated.

    Function Module (II)

    CD_EVALUATION_PERIODS

    call function 'CD_EVALUATION_PERIODS'

    exporting

    bonus_date = ref_periods-bondt

    inper_modif = pn-permo

    inper = ref_periods-inper

    pay_type = ref_periods-payty

    pay_ident = ref_periods-payid

    tables

    rgdir = rgdir

    evpdir = evp

    iabkrs = pnpabkrs

    exceptions

    no_record_found = 1.

    Authorization Check

    Authorization for Persons

    In the authorization check for persons, the system determines whether the user has the

    authorizations required for the organizational features of the employees selected with

    GET PERNR.

    Employees for which the user has no authorization are skipped and appear in a list at the end

    of the report.

    Authorization object: 'HR: Master data'

    Authorization for Data

    In the authorization check for data, the system determines whether the user is authorized to

    read the infotypes specified in the report.

    If the authorization for a particular infotype is missing, the evaluation is terminated and an error

    message is displayed.

    Deactivating the Authorization Check

    In certain reports, it may be useful to deactivate the authorization check in order to improve

    performance. (e.g. when running payroll)

    You can store this information in the object 'HR: Reporting'.

    HR-D: Payroll Germany

    RP_LAST_DAY_OF_MONTHS

    HR-D: Determine last day of month

    regards

    vinod

  • RELEVANCY SCORE 2.71

    DB:2.71:Counting Columns 7x


    How can I write a query to find the number of columns in a table? (Count of Columns / number of field in the first row)

    DB:2.71:Counting Columns 7x

    Thanks everyone. I was able to get the answer with ALL_TAB_COLUMNS

  • RELEVANCY SCORE 2.71

    DB:2.71:Crosstab Counting Two Seperate Tables da



    Our streetlighting inspection is based on areas. I have a table with the lighting inventory and can do a crosstab showing me how many columns per inspection area.

    The recorded defects from the inspection are held in a different table and I can do a crosstab showing defects per inspection area.

    I would like to end up with a report where the inspection area, No of Columns and No of defects are all on the one line.

    Any suggestions on how I should approach this.

    Thanks

    Ron

    DB:2.71:Crosstab Counting Two Seperate Tables da


    If you have any link between the tables then add both the fields in the crosstab in field to summarize and use the summary option as count.

    Regards,

    Raghavendra

  • RELEVANCY SCORE 2.71

    DB:2.71:Countifs Not Counting Every Occurance In The Range jk


    I have a range of data in two columns, with headers so I have converted it to a table as I will be adding to it. My formula uses COUNTIFS to count the number of times that D occurs between two dates.

    The formula is =COUNTIFS(Table1[Direct Status],"="D3,Table1[Enq Date],"="$E$1,Table1[Enq Date],"="$F$1).
    I do not get any error so I know it is working however it is not counting correctly. In my table range of 923 rows, the letter D occurs 423 times, yet the formula result is on 82. I have checked the data and there are no spaces before the letter D or
    any missing values. The dates are all in date format too.
    I am mystified. Can you suggest why it is not working.

    Thanks.

    DB:2.71:Countifs Not Counting Every Occurance In The Range jk

    Further checks on the date field show that when I do a filter I only get text filter options. Filtering for some of the dates in March which it wasn;t including in the result and overtyping them as the date has now included them in the totals.

    so my issue is that some of the dates, whilst looking like dates are actually text. Using DATEVALUE I have identified the text dates and pasted the DATEVALUE result over the text dates.
    I now have results more like what I would expect.
    Thank you for your support. maybe I just needed a clear head as I had been wrestling with it for a while last night.

  • RELEVANCY SCORE 2.71

    DB:2.71:Counting The Days From A Date To The Start/End Of The Month kx


    I am working with a data set that has billing cycles. Sadly the billing cycles do not correspond exactly with the start and end dates of the months. I have a column STARTDATE and a column ENDDATE both formatted as dates: yyyymmdd.
    I need another two columns, one that counts from the STARTDATE to the end of the month i.e. if STARTDATE is 1/20/2011 then count the days until 1/31/2011,

    and another that counts back from the ENDDATE to the start of the month, i.e. if the ENDDATE is 2/20/2011 then count back to 2/1/2011.

    Is there any way to do this? The reason is that I need to proportion monthly variables to the billing cycles and of course for a number of the people billed they each have a unique start and end date each month.