Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
REON_LEE
Partner
Partner

How to transform variable values from excel into QlikView table

Hi All,

Anyone can suggest to me how to transform the list of variable values from excel into the table.

I have defined 2 columns, the variable name(Variable) & variable values(VarExpression).

My initial intention was to load the variable into QlikView , then match the list of values during the where clause. 

But I failed, this is because some values are in the number & text format.

VariableVarExpression
vFinPurchaseGood101,102,903,904,Z01,Z02,561,912,Z05,Z06
vFinAdjustment905,906,907
vFinTransferOutZ03,641,

 

The result will look like below:

VariableVarExpression
vFinPurchaseGood101
vFinPurchaseGood102
vFinPurchaseGood903
vFinPurchaseGood904
vFinPurchaseGoodZ01
vFinAdjustment905
vFinTransferOutZ03

.......cont.

Any suggestion is highly appreciated.

Regards,

Reon

1 Solution

Accepted Solutions
sunny_talwar

Try SubField function

 

Table:
LOAD Variable,
	 SubField(VarExpression, ',') as VarExpression;
LOAD * INLINE [
    Variable, VarExpression
    vFinPurchaseGood, "101,102,903,904,Z01,Z02,561,912,Z05,Z06"
    vFinAdjustment, "905,906,907"
    vFinTransferOut, "Z03,641"
];

 

 

View solution in original post

2 Replies
sunny_talwar

Try SubField function

 

Table:
LOAD Variable,
	 SubField(VarExpression, ',') as VarExpression;
LOAD * INLINE [
    Variable, VarExpression
    vFinPurchaseGood, "101,102,903,904,Z01,Z02,561,912,Z05,Z06"
    vFinAdjustment, "905,906,907"
    vFinTransferOut, "Z03,641"
];

 

 

View solution in original post

REON_LEE
Partner
Partner
Author

Hi Sunny,

Your suggestion is very useful, Thank you very much!