topic Re: Associated field coming through as two different data types on load in App Development

Associated field coming through as two different data types on load

sicdude — Fri, 02 Apr 2021 08:27:58 GMT

I have a multi-concatenated data table from different data sources that all use (we'll call it) ClientID. I also am seperately importing the Client table with the name, address, phone# ect...

all of the originating data sources have this field as a varchar(9) in SQL. Some of the values of ClientID might have leading zeros which is why it is a varchar and not an integer.

My main datatable imports it fine, but the Client table gets imported as a number and is causing my association on the field, from the main datatable to the Client table, to not work properly

what might I need to do to alter my import script to fix this?

Re: Associated field coming through as two different data types on load

Nicole-Smith — Mon, 01 Jun 2020 22:01:58 GMT

In your load, you can wrap the field in the text() function to keep it as a text value:

Table:
LOAD Text(ClientID) AS ClientID, Field2, Field3;
SELECT ClientID, Field2, Field3
FROM SqlTable;

Re: Associated field coming through as two different data types on load

sicdude — Tue, 02 Jun 2020 13:27:00 GMT

it's always the simplest things that cause the biggest headaches. The bane of my programming career is the smallest little things 🙂 Thank you!