Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to return the first value in key field from my data but i got an error which :
Table ' New Data ' Not Found.
this my code :
NewData:
Generic LOAD
Key,
attribute,
Value
FROM [lib://personal (desktop-dpummb2_yaman)/Personal Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Load FieldValue('Key',1) as MyPos1
Resident NewData;
If you only need one value, why don't you use a variable instead of a field?
let vMyPos = FieldValue('Key',1);
let me know if this helps. Regards.
-- Discard this comment, I've read your last post.
May be all you need is to use AutoGenerate instead of Resident load?
LOAD FieldValue('Key',1) as MyPos1
AutoGenerate 1;
My table called Sheet1.Color Consist of two fields : Key and Color and my aim is to know the value of the key whatever the record is.
i typed
LOAD FieldValue('Key',1) as MyPos1
AutoGenerate 1;
but i expect the value of key inside MyPos1 but nothing happened .
Would you be able to share a sample of the script where you are trying this?
I wonder if Generic Load has to do anything with it... so what are you getting for MyPos1 and what do you intend to see?
yes Firstly my Data is
After Generic load i get these tables
What i want to do is to convert these tables to two tables based on the key (one table for Person and other for Car including their attributes)
so what i thought is to collect tables having Person key in one list and applying inner join to them
and do the same thing for Person key
after that i will get two tables one for Car and other for Person
I hope you can get the idea from my explanation.
If you have better solution please share it with me.
If you only need one value, why don't you use a variable instead of a field?
let vMyPos = FieldValue('Key',1);
let me know if this helps. Regards.
-- Discard this comment, I've read your last post.
Thanks .
I tried but does not work but it should be without let
I mean like this :
MyPos1= FieldValue('Key',1)
Here is very well explained how these tables could be joined: The Generic Load.
- Marcus