Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sumitjadhav
Creator II
Creator II

i want to combine two different fields into one single field then how to do it without using composite key?

i want to combine two different fields  into one single field then how to do it without using composite key?

the condition is as follows:

Load *Inline [

Region,sub-region,Date

R1         Sb1          1

R2         Sb2          2

R3         Sb3          3

R4         Sb4          4

R5         Sb5          5

];

I want the output as below,

Dimension(field)

R1

R2

R3

R4

R5

Sb1

Sb2

Sb3

Sb4

Sb5

5 Replies
oknotsen
Master III
Master III

Combining them into 1 field is THE way of doing this (as also mentioned in your previous topic).

Sure, you could glue them together in the front end, but why waste performance on that?

May you live in interesting times!
avinashelite

try like this :

Temp:

Load *Inline [

Region,sub-region,Date

R1         Sb1          1

R2         Sb2          2

R3         Sb3          3

R4         Sb4          4

R5         Sb5          5

];

LOAD sub-region as Region

resident

Temp;

But it may lead to wrong result rite?? What is your exact requirement

oknotsen
Master III
Master III

Please do NOT start the same topic twice (in two different area's).

Other copy rejected and deleted.

May you live in interesting times!
oknotsen
Master III
Master III

How would it lead to the wrong result?

May you live in interesting times!
sumitjadhav
Creator II
Creator II
Author

sorry for the wrong condition again iam sending you the same scenario but i want new field to be created i.e, dimension.