Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

Billing File new.xls

Not applicable

Billing File new.xls

Hi all ,

In that attached excel file material4 coloumn 'TAB' and 'SMP' needs to show 'REL' coloumn for that i need script any one help me for that.

Comments
undergrinder
Valued Contributor II

Hi Pramod,

Try this insert into your load script:

,if(material4='TAB' or material4='SMP',REL,material4) as ColumnNameYouWant

G.

Not applicable

i tried but i am getting this error Field not found - <REL>

tab3:

LOAD*,

if([Material Group Desc.]=material,'REL', if([Distribution Channel]=81,'SMB', if([Distribution Channel]=11,'CON',[Material Group Desc.])))as REL4,

if(material4='TAB' or material4='SMP',REL,material4) as ColumnName

 

Resident tab2

undergrinder
Valued Contributor II

Hi Pramod,

The shared excel contains this column,

your script is based on tab2. doesn't tab2 contain REL column?

G.

Not applicable

no my quaation is material4 coloumn data i.e, SMP and TAB to reflect REL coloumn .

undergrinder
Valued Contributor II

Could you share with as an example qvf?

Thank you!

Version history
Revision #:
1 of 1
Last update:
‎02-25-2016 04:12 AM
Updated by: