![]() And press ctrl + c,then will go to the column in which data is to be pasted.and then press alt + E S and then go. ie: PrimaryKeyĬan I pivot the data from a row to a column and then test it for a result? Once I've used the pivoted data I can drop it. First, you will select the data from the rows. ![]() I think this these fields could be better tested if they ran down the page. Now my MATCH will have to be nested into IF statements so that I end up with one new field that states what this patient had. But I also have to check for numerous other procedure codes - just a select list. I have to build some sort of MATCH to identify and label this patient as Adnoidectomy. Drag the mouse pointer up or down to select the desired number of rows. First step we connect excel Perform transform to change data types Now I want to create another table where headers will be rows for new table + additional columns having info like text colum will mark as category variable Numeric will mark based on its range like 0-100 1-10 Etc. To include this you will first need to demote the column headings to a row in the data. Place the mouse pointer on the row number in the row header. Say I am asked to identify where a patient has had a procedure of Adnoidectomy (41801-00). Some of the data you might want to transpose will be in the column headings. See below an example of the data as it currently resides in QV. I believe this would be easier to do if the procedure and diagnosis codes were in their own table with a row for each one and a primary key linking back to the main patient record. I have to scan along these codes looking for certain matches, then apply a label to this patient's record accordingly. The data captures 100 possible procedure codes and 100 possible diagnosis codes (yes, the application is health). I am using the script to split out and label each field and that has worked well so far. ![]() ![]() I have a large 'fixed length' data file (TXT) that I am bringing into Qlikview.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |