Subfield

Anonymous — Tue, 06 Feb 2018 12:44:57 GMT

Hi everyone,

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:

Load distinct,

Countries,

Product

Comment

subfield("ID", ',', 2) as UnID

resident PROD2018;

drop table PROD2018;

rename Table PROD2018temp to PROD2018;

Thank you in advance,

Mauro

Re: Subfield

sunny_talwar — Thu, 08 Feb 2018 16:50:02 GMT

Try by removing the 2 from your SubField function

SubField("ID", ',', 2) as UnID

Load distinct,

Countries,

Product

Comment

subfield("ID", ',') as UnID

resident PROD2018;

drop table PROD2018;

rename Table PROD2018temp to PROD2018;

Re: Subfield

Anonymous — Mon, 12 Feb 2018 15:07:48 GMT

Thank you Sunny!

I will try and I will let you know if this works.

Mauro

topic Subfield in QlikView

Subfield

Re: Subfield

Re: Subfield