Forum Discussion
M Query to match columns with table
I have a table that contains rows with the following data: - Column "CustomDataTables" that contains a table - Column "lookupname" that contains a String value (name of the table) - Column "ValueT...
And is that what you want? A single record in each row with the value of [ValueThatMayNeedToBeReplaced] and a Field name of [lookupvaluefield]?
yes - as a first step I need a single record - then I am using this record to find (TRUE/FALSE) if it is contained on the table contained on [CustomDataTables]. Then I am filtering the records based on "TRUE".
Ultimately, I am trying to get the lookupvaluetextfield from the table contained on [CustomDataTables]