Discussion Board for collaboration on QlikView Scripting.
I have two fields as below:
the first field is Descriptions and the second field is values.
I have separated descriptions to a separate table as below using script
I have separated values to a separate table as below using script
Now, my final output should be as below. How can i achieve this?
I have tried using Concatenate but that does not help.
Look at this example
Thanks for the response Yuri. I have field descriptions in one column and field values in another column. Using those two fields i am trying to create a table in Qlikview.
Your out treats everything as data.
Instead of having Table.A, TESTE, TESTE2 as column headers. I want Agreement_No, Agreement_Desc, Agreement_Amt as column header and the value in TESTE2 field above arranged as below.
I am attaching the file, that i have used.
Please let me know your thoughts.
Ok, try this!
That works perfect but just one more thing in here.
It works fine for static structure but flat file will have structure that will change depending on scenario.
for instance the flat file might have additional field and value.
In such case, my output should be as below without changing the script:
This is how i was able to achieve it. PFA file.
Thanks a lot Yuri!.