This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have file as below
Is there a way to separate Latitude and Longitude from FieldLabel and make those as 2 separate columns ?
What you are looking at is a Generic load. However, since it only involves two generic fields I would find it easier to hard code it like this:
FieldValue as Latitude,
(html, codepage is 1252, embedded labels, table is @3)
Where FieldLabel = 'Latitude';
FieldValue as Longitude,
Where FieldLabel = 'Longitude';
View solution in original post
Try this way in the script
If(match(FieldLabel,'Latitude','Longitude'),FieldLabel) as LatLong,
If(Not match(FieldLabel,'Latitude','Longitude'),FieldLabel) as NotLatLong
This didnt work.
Create 2 new measure....
if(FieldLabel='Latitude', 'Latitude') and name the Label as Latitude
if(FieldLabel='Longitude', 'Longitude') and name the Label as Longitude
It will create new columns but all the rows will be null and only the rows matching Latitude & Longitude will show same values.
And if you use
if(FieldLabel='Latitude', 'Latitude',FieldLabel ) will give you Latitude for latitude row and rest of the rows will show same data as FieldLabel but you'll just have a new Column.
What is the out put for the new field let me know.
Will it be only Latitude , Longitude on the field if so then it is correct
Show your out put please.
Do you want that Lat and Long assigned to every row?
Above is the original table and I want the out put as below.
Latitude Longitude RecordType RecordID
-37.81763 144.9575 Expense 65150
It can ignore all other columns and rows.Latitude and Longitude value is coming from FieldValue column.Cross table should work for this ?
Below is the original table and I want the out put as below.
Thank you very much.