search

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Load Chain - USA #82

Open AVHuntley opened 1 year ago

afs1jes commented 1 year ago

disabled rebuild corrected bad field name on RetailerMaps sheet.

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'