search

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Load Chain - AUTO - without clear #80

Open AVHuntley opened 1 year ago

AVHuntley commented 1 year ago

Updated SQL grid on FlipOnLoad sheet. Added 'dummy' column to the left of the grid that allows AccountNumber formula to get copied down correctly.

New SQL query: SELECT '' AS AccountNumber, AccountsName, AccountType FROM [Dimension].[Accounts] where AccountType = '-1'

AVHuntley commented 1 year ago

I made a change to this template based on some issues found on the "Load Chain - AUTO" template. Two SQL grids had duplicate or invalid column names, so those were causing some issues. Should be fixed now.