From 6d2091f91a8b16a17acdf0c9ada085130e82df14 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Wed, 20 Dec 2023 01:12:50 +0300 Subject: Update handling of RGD_ID field in genelist metadata transform. Signed-off-by: Munyoki Kilyungi --- examples/genelist.scm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/examples/genelist.scm b/examples/genelist.scm index 7bee085..61d2174 100755 --- a/examples/genelist.scm +++ b/examples/genelist.scm @@ -251,7 +251,8 @@ (set gnt:hasUnigenID (string-trim-both (field GeneList UnigenID))) (set gnt:hasProteinID (string-trim-both (field GeneList ProteinID))) (set gnt:hasAlignID (string-trim-both (field GeneList AlignID))) - (set gnt:hasRgdID (field GeneList RGD_ID)))) + (set gnt:hasRgdID + (field ("IFNULL(RGD_ID, '')" RGD_ID))))) (define-transformer genelist-rn33 (tables (GeneList_rn33)) -- cgit v1.2.3