Error happened when using FieldValue Function

[Anonymous]

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;

[sunny_talwar]

May be all you need is to use AutoGenerate instead of Resident load?

LOAD FieldValue('Key',1) as MyPos1

AutoGenerate 1;

[Anonymous]

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 .

stalwar1‌

[sunny_talwar]

Would you be able to share a sample of the script where you are trying this?

[Anonymous]

[sunny_talwar]

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?

[Anonymous]

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.

[diego_a_barboza · Accepted solution]

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.

[Anonymous]

Thanks .

I tried but does not work but it should be without let

I mean like this :

MyPos1= FieldValue('Key',1) 

[marcus_sommer]

Here is very well explained how these tables could be joined: The Generic Load.

- Marcus