Concat field Values

[Anonymous]

Hi All,

I am having columns F1  in T1 and F2 in T2. The F1 will have the unique values and F2 will have more than one values for same F1 value.

T1:

[F1

1

2

3

4

5

]

T2:

[F1,F2

1,AA

1,BB

2,C

3,DD

3,EE

]

Expected O/P

[1,AA,BB

2,C

3,DD,EE]

.

[kaushiknsolanki]

Hi,

Try this.

T2:

Load * inline [

F1,F2

1,AA

1,BB

2,C

3,DD

3,EE

];

output:

Load F1,Concat(F2,',') as NewFIeld

Resident T2 Group by F1;

Regards,

Kaushik Solanki

[Anonymous]

Both are two different table and in my dashboard the data model is different. For your clarity I have used it.

Actually it is Pivot table,there I need to CONCAT the values against each F1 value

[kaushiknsolanki]

Hi,

Then you can use the

Concat(F2,',') as expression in pivot table.

If this doesnt work please share the sample data showing your issue.

Regards,

Kaushik Solanki

[Kushal_Chawda]

if you have F1 as Dimension in Pivot table, you can simply write expression as Concat(F2,',')

[sasiparupudi1]

Try like this

T1:

load * Inline

[

F1

1

2

3

4

5

];

left join(T1)

T2:

LOAD F1,Concat(F2,',') as F2

group by F1;

load * Inline

[

F1,F2

1,AA

1,BB

2,C

3,DD

3,EE

];

NoConcatenate

final:

LOAD F1,F2 Resident T1 where IsNull(F2)=0;

drop Table T1;

[jagan]

Hi,

Try like this

Dimension : F1

Expression: Concat(F2,',')

Hope this helps you.

Regards,

Jagan.