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;

[Anonymous]

Thanks Mr. Marcus

i read this article before and i got good help from it but in this article he explained how to join tables to have one big table but in my case i want to join tables based on key to have two tables.

[Anonymous]

yko‌

shivanandk‌

jvs‌

stalwar1‌

[Yianni_Ververis]

I would not use the word "Key" for any field name.

Here is a simple example o joining 2 different tables "Projects" and "Requests" on request_id

LOAD [project_id] AS [project_id],

[type_id] AS [type_id],

[status_id] AS [status_id],

[request_id] AS [request_id],

LOAD [request_id] AS [request_id],

[industry_id] AS [industry_id],

[isProject] AS [request.isProject],

[title] AS [request.title],

Hope that helps,

Yianni

[Anonymous]

maybe i was trying like your statement but now i tried again and really it is working

Thanks Mr. Diego

[Anonymous]

Actually my data design is dynamic so i need to use key and attribute for each key as it is shown the last images

so i need to convert row data to column data by using generic load after that i will combine tables based on the keys.