Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having some issue getting this concept to work, any suggestion is appreciated.
I have an empty qvd that is generated daily. I would like to get the list of fields from that empty QVD into a new field (Fieldlist).
the script below is returning nothing for field list.
TABLE:
Load * FROM
FIELDS:
CROSSTABLE (Fieldlist, Value)
LOAD 1 as Dummy, *
Resident TABLE
where RecNo() =1;
drop Table TABLE;
DROP FIELDS Dummy, Value;
thanks
TABLE:
Load * FROM
FIELDS:
CROSSTABLE (Fieldlist, Value)
LOAD rowno() as Row,
*
Resident TABLE;
drop Table TABLE;
DROP FIELDS Row, Value;
What are you expecting to see when FieldList is Filter ???
Hi Anil,
am just trying to create a table with my column FieldList that hold all the fields(columns) fro the qvd.
thanks
You said, your QVD is empty. How you are expecting? Does qvd has any structure of Fields with out records?
You said, your QVD is empty. How you are expecting? Does qvd has any structure of Fields with out records?
You said, your QVD is empty. How you are expecting? Does qvd has any structure of Fields with out records?
I mean the qvd columns have no value
Sorry to bougher you replying 3 times. Fortunately, I can't delete because my actions are not working.
Try this?
tabFields:
CrossTable (FieldList, Value) LOAD 1,*
FROM
Where RecNo()=1;
DROP Fields '1', Value;
If not, Can you use something like Where 1 = 2;
TABLE:
Load * FROM
FIELDS:
CROSSTABLE (Fieldlist, Value)
LOAD rowno() as Row,
*
Resident TABLE;
drop Table TABLE;
DROP FIELDS Row, Value;
Thanks Guys. I will apply Kushal idea.