If the number is that small, I would recommend filtering out those values first. Here are the steps you would need to add:
First, add a filter before the "String Operation" where we created the LPAD field
Second, you need to apply the opposite filter so that you only include the three values that don't need 9 digits:
(make sure that you change the setting to include rows that meet "any" of the rules
Third, you need to add a column to the bottom data table that matches the name you created earlier (LPAD in your case). I used "Text_pad" in my sample. It just needs to be the same name.
Fourth, use "Set Column Value" to map the values from your bank_id field to the new field:
Fifth, Append the two data tables:
Then your output will look something like this:
so I believe the card is correct now, problem I'm running into now is the data in this table has to be exported to a CSV, which is then dropping the leading zeroes.
Are you opening the csv file in excel? Excel drops the leading zeros. Open the file in notepad or another text editor and you should see the leading zeros in your csv file.