Combine mutiple columns into one column

shabarish0587 — Wed, 25 Nov 2020 16:16:04 GMT

Hi friends,

I have few columns like ID, Status, Description, Reject_Rsn, Comment. from these columns i need to create a new column based on few search keywords. i created a column as category. But here i have three different category columns but i need to define these three different category columns into one column. Can anyone help me on this. I am sharing sample code here: I have category like 1, 2 and 3 and i want to show in one column like Category with values like Details, Reason, Status.

if(status='withdrawn'
if(match(comment,'Null','N/A'),
if(match(description,'Null','N/A'),'Details'
))) as Category1

if(status='withdrawn',
if(Reject_Rsn='Id was submitted',
if(wildmatch(comment,'*Invalid**','**Mistake**'),'Reason'),

if(Reject_Rsn='Not available',
if(wildmatch(comment,'*Not repeated**','**Not Applicable**'),'Reason'),

if(Reject_Rsn='Duplicate ID',
if(wildmatch(comment,'*Duplicate**','**Simple**','Same'),'Reason'),

if(Reject_Rsn='Designed',
if(wildmatch(comment,'*Expected**','**Designed**'),'Reason'),

if(Reject_Rsn='Not to Fix',
if(wildmatch(comment,'*Business**','**Accept**','**Impact**'),'Reason')
)))))) as Category2

if(status='Withdrawn', if(not(match(comment, 'Withdrawn','Withdrawing')), if(not(match(Description, 'Withdrawn','Withdrawing')),
if(Reject_Rsn='Id was submitted',
if(wildmatch(comment,'*Invalid**','**Mistake**'),'Status'),

if(Reject_Rsn='Not available',
if(wildmatch(comment,'*Not repeated**','**Not Applicable**'),'Status'),

if(Reject_Rsn='Duplicate ID',
if(wildmatch(comment,'*Duplicate**','**Simple**','Same'),'Status'),

if(Reject_Rsn='Designed',
if(wildmatch(comment,'*Expected**','**Designed**'),'Status'),

if(Reject_Rsn='Not to Fix',
if(wildmatch(comment,'*Business**','**Accept**','**Impact**'),'Status')
))))))
))) as Category3

I tried using another method like creating flags and three different columns in one column by using concatenation, but i am not getting expected output. and i have a question here. can we use case condition instead of if condition. can anyone help me on this. Thanks in Advance

Re: Combine mutiple columns into one column

mato32188 — Fri, 14 Jun 2019 11:30:32 GMT

Hi,
could you please share sample of data (xlsx, txt) with your source fields (Reject_Rsn, comment, etc.)?
Thank you.
Martin

Re: Combine mutiple columns into one column

shabarish0587 — Fri, 14 Jun 2019 12:49:38 GMT

Hi Martin,

I am sharing sample file for that. can you please look into this.

Re: Combine mutiple columns into one column

Brett_Bleess — Tue, 16 Jul 2019 21:41:07 GMT

Best I have for you given I am not too swift when it comes to development, is to check out the following link and search around there, as I think you may be able to find something to help you there. Hopefully this may allow you to move things forward.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic Re: Combine mutiple columns into one column in QlikView

Combine mutiple columns into one column

Re: Combine mutiple columns into one column

Re: Combine mutiple columns into one column

Re: Combine mutiple columns into one column