Good day everyone,
i created a transform map for an excel sheet, and one of the columns has a data that i will need to query a custom table with and then output the results from the query to the field upon loading
Basically it will look for the Index of a 10 digit number
ex. 1332331001
the displayed field from the custom table is called "Search" this field has the 10 digit number along with letters and working but they will always have the first 10 characters as numbers
i need to be able to IndexOf the 10 digitals and once it finds the record to output the Search information into the column
How can i create a transform Map script base on that?
This is new to me
