I believe your query only returns a single result, then it is easier to use a single record query. The step will then return the record as an object.
Now you don’t need the repeat1 step and can set the values sd_id and sd_name directly.
After that create a repeat with the expression {{sd_id}}.
in the repeat you set following values for you output:
name: sd_id, value: {{$value.split('_')[0]}}.
name: sd_value, value: {{$value.split('_')[1]}}.
name: sd_name, value: {{sd_name[$index]}}.
Now the repeat should output the array needed as needed in your local datastore.