how to show two column values in one row

[kavita25]

Hi,

sunindia‌

I want to show column1 values and 2nd column in one row..

For e.g

Id  Column1   Column2

1      125             -

1       300             -

1        -                  520

1        -                  452

Result:

Id  Column1   Column2

1      125              452

2       300             520

Please help me with this issue.

Regards,

Kavita

[jonathandienst]

Where does the 2 in the second line come from?

Use a straight table with ID as the dimension, and Sum(Column1) / Sum(Column2)

or Concat(Column1, ',') / Concat(Column2, ',')  as expressions.

[kavita25]

I want it in different row...concat wont work... and my column1 and column 2 is in string...

[sunny_talwar]

How did the result get id = 2? The source only seem to have id = 1?

[jonathandienst]

You can't do much else with the sample data you provided.

[kavita25]

PFA..

[kavita25]

The id will be the same for both the columns, only the problem is...its not showing in one row..

[Anonymous]

HI,

It seems that in your model you have a table loaded like this:

Id  Column1   Column2

1      125             -

2       300             -

1        -                  520

2        -                  452

You should load it differently.

For example, if your table's name is TABLE, then:

TABLE_FINALE

LOAD

Id,

Column1

RESIDENT TABLE;

JOIN (TABLE_FINALE)

LOAD

Id,

Column2

RESIDENT TABLE;

DROP TABLE TABLE;

Then you will have this table:

Id  Column1   Column2

1      125              520

2       300             452

[kavita25]

the numbers are repeated twice..after using ur query

[jonathandienst]

I cannot see any data or object on your sample that fits the problem described in your original post.