I’m pulling data in from an Excel sheet making some alterations then pushing it back out again. However there is the possiblity that the data the script is looking for hasn’t previously been created in wihich case I want to insert a default value.
To do this I’ve tried to use an IF statement to detect if there is an empty list but for some reason regardless of the check, if a value being inputted into my if statement is an empty list it returns an empty list even if the statement is true…
Can anyone tell me why this doesn’t work or maybe point me in the direction of an alternative solution?