Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have table that consist
Pid, Pname
1 ,mango
2 ,coriander
3 ,pepper
if the pid again comes it needs to same columns beside like following
pid, pname, pid, pname
1 ,mango, 1 , banana
2 ,coriander
3 ,pepper 3 ,sapota
dynamically it needs to add columns to table if the same pid is comimg again and again . how can i achieve please help me.
I dont think this is possible to achieve without using macros. Why are you trying to do this?
how exactly is pid coming again?
What was the logic behind? Where you are getting pid again? Will you able to explain little more?
in the same pid different pnames are there, if the same pid and different pname comes it needs to add separate column to the straight table
HI Anil,
I have following table,
state code ,dist
111 ,guntur
111 ,prakasam
111 ,ongole
222 ,adilabad
222 ,khammam
333 ,vadi
I want to show above data to like as follows
state code ,dist ,dist ,dist
111 ,guntur ,prakasam ,ongole
222 ,adilabad, khammam
333 ,vadi
is it posssible to show like this please help me
Thanks & Regards
Anjaneyulu
would this work?
Create a Straight table
Dimension
StateCode
Expression
Concat(Distinct dist,'; ')
hi vineeth,
not in single column ,it needs to create separate columns
Haha, That's not possible. Could be possible with Adhoc Reports. Work around may be this?
Using vineeth's expression try like below:
Table1:
LOAD statecode, subfield(distance, ';',1) AS dist1,
subfield(distance, ';',2) AS dist2,
subfield(distance, ';',3) AS dist3;
LOAD statecode, Concat(dist,';') AS distance
Group By statecode;
LOAD * INLINE [
statecode ,dist
111 , guntur
111 , prakasam
111 , ongole
222 , adilabad
222 , khammam
333 , vadi
];