Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have three spreadsheets.
I want to load the spreadsheets and set an additional field so I know the source.
Below is my logic for loading the files
Crossreference:
LOAD ASSETNAME as 'hostname',
FROM
(
noconcatenate;
snapshot:
LOAD ASSETNAME as 'hostname',
FROM
(
noconcatenate;
assetinv:
LOAD ASSETNAME as 'hostname',
FROM
(
If I join all three tables together, I get a master list of hostnames, but I lose the source of which file it resides in.
How can I create 'something' so I can create a table object and be able to see which file had the data.
May be try this:
Crossreference:
LOAD ASSETNAME as 'hostname',
'Crossreference' as Source
FROM
(
Concatenate(Crossreference)
LOAD ASSETNAME as 'hostname',
'Snapshot' as Source
FROM
(
Concatenate(Crossreference)
LOAD ASSETNAME as 'hostname',
'Assetinv' as Source
FROM
(
add a field for source
Crossreference:
LOAD
ASSETNAME as 'hostname',
1 as 1stSource
FROM
(
1 as 2ndSource
1 as 3rdSource
Try the following:
Crossreference:
LOAD ASSETNAME as 'hostname',
FROM
(
LOAD ASSETNAME as 'hostname',
FROM
(
LOAD ASSETNAME as 'hostname',
FROM
(
Thanks for the suggestions on the FirstSource, SecondSource, ThirdSource
My challenge now .. if I display the joined data in a Table Box, how can I search/filter where the hostname is only in FirstSource or the hostname is in the ThirdSource.
I think the blanks or nulls as a result of a join are stopping me from being able to filter on it.