Discussion Board for collaboration related to QlikView App Development.
Recently I was working with the function subfield and I had some minor problems.
I had a table with countries and IDs and some countries had multiple IDs, so I used subfield to extract and associate one ID per country.
Now, it happened that the function created a new column next to the IDs (IDs 2, let's say) in which the "second" IDs are contained, but the number of rows it's still the same.
I would like to maintain one column of IDs and ideally "duplicate" the row, with all the info associated to the ID.
In previous examples that I saw on the community the "duplication" was automatic, but that is not my case, do you have any suggestions?
This is the code that I wrote:
subfield("ID", ',', 2) as UnID
drop table PROD2018;
rename Table PROD2018temp to PROD2018;
Thank you in advance,
Try by removing the 2 from your SubField function
SubField("ID", ',', 2) as UnID
subfield("ID", ',') as UnID
Thank you Sunny!
I will try and I will let you know if this works.