Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Thank You for all your support.
I solved it.
For reference PFA.
Regards,
Kavita
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.
I want it in different row...concat wont work... and my column1 and column 2 is in string...
How did the result get id = 2? The source only seem to have id = 1?
You can't do much else with the sample data you provided.
PFA..
The id will be the same for both the columns, only the problem is...its not showing in one row..
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
the numbers are repeated twice..after using ur query
I cannot see any data or object on your sample that fits the problem described in your original post.