Lookup activity returns incorrect column/values from altered Fabric table ho ho Ho Gaya Bihar India

[Gwgwh]

goo goo the following ad the following URL and paste to the email address is not aTi amo mi iPad theI use a lookup table to get orchestration data from a Fabric table. The table was altered to add a column. If I perform an insert into the table where the added column is not the last value in the insert statement, the lookup will fail.

Too much of the email address to

In this example, the ORCHESTRATION table was altered to add the SRC_FOLDER column. Id = 41 was inserted with SRC_FOLDER as the final column, where Id in (54,55) were not.

Below is part of the the output from Lookup.  SRC_FOLDER should always be "dataEngDev".

{Hiiii the email address is not available

[Anonymous]

Hi @Gwgwh ,

The problem may be related to the way the Lookup activity retrieves data from the table. You may need to ensure that the new column is always the last value in the insert statement, or adjust the lookup query to account for the location of the new column.

Refer to below document:

Lookup activity - Microsoft Fabric | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.