Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Is it possible to get the field names from the source Table but not the data. forexample by using FileBaseName() , i get name of the File only.
ForExample:
ID | Name |
1 | Rahul |
2 | John |
When i load the above table in Qlikview ,i should get one column containing the Name of the Field (i.e. ID and Name) but no data.
i only need field names. Is it possible????????
The keyword NoOffields count the fields based on already loaded data.So if you wont give it will give error in for loop
Any way to get the values of all fields inside a New Field or Is it possible to get the field values from the source Table.
Hi Manish,
You can try with this will not load any rows
Load
Id,
Name
Where RowNo() = 1;
Hi Manish,
In Oracle you can use the below query. What is your source database?
SELECT column_name
FROM all_tab_cols
WHERE table_name = 'users'
AND owner = ' || +_db+ || '
AND column_name NOT IN ( 'password', 'version', 'id' )
old thread, but one solution could be:
tabFields:
CrossTable (FieldName, val) LOAD 1,*
FROM Source
Where RecNo()=1;
DROP Fields '1', val;
maybe it helps
regards
Marco
Did you try this load script
Load
Id,
Name
Where RowNo() = 1;
Regards
Anand