Issues With SQL Lookup Transformation

More
1 year 2 months ago #25138 by battlemedialab
I'm attempting to use the SQL Lookup transformation tool and running into an issue with having it run properly and store the resulting value back into the Excel spreadsheet.

The client we're working with has an Excel spreadsheet exported from Shopify, which we need to use the unique identifier Variant SKU to query the database for the available quantity, then record said value back into the spreadsheet.

I have the transformation reading & writing back the values, with the exception of the Variant Item Qty which is needing to query the database to get its value. Am I doing something incorrectly --- this is my first time utilizing this particular ETL feature and the video that was on the documentation page for SQL Lookup didn't refer to this feature in particular.

Please let me know if there's any other information you are needing to help assist with.
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago #25139 by admin
Hi

If you look very carefully you will notice that the parameter name is "Variant SKU" (parameters tab) but on source tab it is "<Variant SKU>", they should be the same
 

Mike
ETL Architect
The following user(s) said Thank You: battlemedialab

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago #25147 by battlemedialab
I made that change (assuming it should be <Variant SKU> used for both of them?), but no luck.

I've attached an PDF export of the log for the most recent attempted run, unless I'm misreading the output it seems like the transformation isn't actually running during this? (As it technically should set the value in those cells to "0" instead of being blank, based on the settings.)
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago #25148 by admin
If you want to extract Variant Item Qty using Variant SKU why SQL Lookup is mapped to Variant Item Qty input and not Variant SKU.

Please see the picture, Also if you press preview button you will see what is going on.


Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save